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.
You’re writing software to manage a chain of movie rental stores.
Write the SQL statements that implement functions of your rental store management system. You may want to use this starter script: sakila-queries.sql.
Why does this query return the empty set?
select * from film natural join inventory;
Don’t peek until you’ve tried the exercise!