Practice Set 5
Explore how to apply SQL analytic functions by writing queries that calculate running totals, moving averages, and monthly revenue growth using movie screening data. This lesson helps you develop hands-on skills to manage and analyze relational data with practical examples.
We'll cover the following...
Practice Set 5
For the purpose of demonstrating analytic 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: