Practice Set 6
Explore SQL analytic window functions and aggregation techniques by working with movie database queries. Learn to rank movies, calculate statistical measures, find correlations, and analyze market share through practical exercises in a real SQL environment.
We'll cover the following...
Practice Set 6
For the purpose of demonstrating analytic window functions, we added a new MoviesScreening table and added some columns to the existing Movies table. The relevant portion of the database relationship model is printed below.
Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/quiz2.sh and wait for the MySQL prompt to start-up.
Write and execute queries for the following questions:
-
Find the top ...