Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how do I get this program to show only information from the year 2015. (SQL) select ENSEM so.sales_outlet_name as Outlet Name, S.sales_year as Year, to_char(sums.sales_quantity),

how do I get this program to show only information from the year 2015. (SQL)image text in transcribed

select ENSEM so.sales_outlet_name as "Outlet Name", S.sales_year as "Year", to_char(sums.sales_quantity), '99999') as "Quantity Sold" from inner join sales 5 sales_outlet so on s.sales_outlet_id = so.sales_outlet_id S.sales_year, so.sales_outlet_name so.sales_outlet_name,s.sales_year group by 18 Outlet Name Year Quantity Sold BERLIN BIKES 2015 638 BERLIN BIKES 2016 869 BIKES SYDNEY 2015 568 BIKES SYDNEY 438 CAIRNS BIKE SHOP 2016 2015 2016 2015 CAIRNS BIKE SHOP 353 391 352 194 KANSAS CITY BIKESHOP KANSAS CITY BIKESHOP 2016 MUNICH BIKE STORE 2015 498 MUNICH BIKE STORE 2016 478 MUNICH BIKES 2015 352 ORACLE 2020 Oracle Corporation. Privacy Terms of Use Integrated Cloud o oud Oracle Learning Library. Ask Tom - Dev Gym - Database Doc 190, 180, 12c. Follow on Twitter Applications & Platform Services Live SQL 19.4.2, running Oracle Database 19c Enterprise Edition - 19.5.0.0.0 Built with using Oracle APEX

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago

Question

3. How has e-commerce transformed marketing?

Answered: 1 week ago