/* 

Enter you SQL below each problem statement.

Run your solution script in SQL Developer and save the 
output as a TXT or SQL file.  

Make sure your output file does not have errors.  

Do NOTE remove the PROMPT commands because 
they identify output for each problem solution.

Submit your solution file and output file on line.


*/

set pagesize 50;
set sqlformat ansiconsole;

show user;
select sysdate from dual;

PROMPT *******************************
PROMPT 6.2.1
PROMPT

/* VIDEOS

Group by the video main topic and give a count of the videos in this 
topic, the maximum video length, the minimum video length, the 
average video length. 

Use column aliases for the aggregate functions (keep the column name 
short, such as "MAX" and NOT "Max Video Length").

Sort by main topic.


*/





PROMPT *******************************
PROMPT 6.2.2 
PROMPT
/*  Oracle OE

Show how many orders each customer has made.  

Show the customer's ID, first and last name along with 
the order count.

Use a column alias for the order count.

Sort by count in descending order and then by last name. 

*/





PROMPT *******************************
PROMPT 6.2.3
PROMPT
/*  
Oracle OE

Count how many times a product has sold in February of 
any year.

Show the product ID, name and and # of times sold.

Sort by # of times sold in descending order and by 
product name.



*/






PROMPT *******************************
PROMPT 6.2.4
PROMPT
/* VIDEOS

Show how many total views of each video in the SQL BASIC series on 
on November 15, 2016.  

Note:  You can't just count the number of records in WATCH_DATA because 
that record has the count of views for a particular video on a particular 
day for a particular country (geography).  How will you get the total views?

Show the video's short title, the date watched and the view total.

Sort by short title.
*/