Lab | SQL Joins on multiple tables
In this lab, you will be using the Sakila database of movie rentals.
Instructions
- 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.
- What is the average running time of films by category?
- 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?