In this lab, you will be using the Sakila database of movie rentals.
- How many copies of the film Hunchback Impossible exist in the inventory system?
- List all films longer than the average.
- Use subqueries to display all actors who appear in the film Alone Trip.
- Sales have been lagging among young families, and you wish to target all family movies for a promotion. Identify all movies categorized as family films.
- Get name and email from customers from Canada using subqueries. Do the same with joins.
- Which are films starred by the most prolific actor?
- Films rented by most profitable customer.
- Customers who spent more than the average.