In this exercise you will write more advanced queries on a database designed to resemble a real-world database system, MySQL’s Sakila Sample Database.

Problem Description

You’re writing software to manage a chain of movie rental stores.

Solution Description

Write the SQL statements that implement functions of your rental store management system. You may want to use this starter script: sakila-queries.sql.

  1. Download the schema and data scripts for the Sakila Sample Database.
  2. Write an SQL script with queries that answer the following questions:

Sample solution

Don’t peek until you’ve tried the exercise!