Practice Set 6
Let's practice querying the tables using aggregate functions.
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 ...