In this lab, you will be using the Sakila database of movie rentals.
- Write a query to display for each store its store ID, city, and country.
- Write a query to display how much business, in dollars, each store brought in.
- Which film categories are longest?
- Display the most frequently rented movies in descending order.
- List the top five genres in gross revenue in descending order.
- Is "Academy Dinosaur" available for rent from Store 1?
- Get all pairs of actors that worked together.
These questions are tricky, you can wait until after Monday's lesson to use new techniques to answer them!
- Get all pairs of customers that have rented the same film more than 3 times.
- For each film, list actor that has acted in more films.