/*
Advanced SQL

Put your SQL solutions below each problem statement.  When 
your solutions run without errors, run all of them via the
"run script" option in SQL Developer.  Save the output to a 
file.

Submit both your solution file and the output file online.

*/

show user;
select sysdate from dual;


PROMPT  ***********************;  
PROMPT 6.7.1;
PROMPT;

/*  Videos

Type I

In 2017 show which countries have watched all the videos 
in the SQL Advanced series.  

Show the region, country ID, name (geography) and count 
of videos watched.

Sort by region, and country name.

Show the subquery code and output first then the whole query.


*/

PROMPT subquery;
PROMPT;

--Determine how many videos there are 
--in the SQL advanced series.




PROMPT full query;
PROMPT;

--Show which countries have watched all the 
--SQL Advanced videos in 2017.
--You will need to use count(distinct ...) so each 







PROMPT  ***********************; 
PROMPT 6.7.2;
PROMPT;
/*  
Views

Make a view of the full query above.

Show the content of that view using SELECT * ....

Be sure to use CREATE OR REPLACE .... when creating the 
view.


*/


PROMPT The view is created;
PROMPT;


PROMPT Show the view content;
PROMPT;