In this lab, you will be using the Sakila database of movie rentals.The database is structured as follows:
- 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 the longest?
- Display the most frequently rented movies in descending order.
- List the top five genres by gross revenue (total amount of income) in descending order.
- Is "Academy Dinosaur" available for rent from Store 1?