Answered step by step
Verified Expert Solution
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)
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 APEXStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started