Practice Set 4
Let's practice querying the tables using the basic conditions and aggregate functions to view the information in a database.
We'll cover the following...
Practice Set 4
The database relationship model is reprinted 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/quiz.sh and wait for the MySQL prompt to start-up.
Write and execute queries for the following questions:
-
Write a query to display the average collection in millions of producers who have produced more than one movie. ...