Search⌘ K
Home
Courses
An Introductory Guide to SQL

Practice Set 4

Explore practical SQL exercises that challenge you to write queries for average calculations, actor-producer relationships, table updates, and custom ranking without LIMIT. This lesson helps you enhance your query writing and database handling skills through hands-on practice.

We'll cover the following...

Practice Set 4

The database relationship model is reprinted below.

widget

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.

Terminal 1
Terminal
Loading...

Write and execute queries for the following questions:

  1. Write a query to display the average collection in millions of producers who have produced more than one movie. ...