PS4
Toolkit
- 1
Film Rentals. The marketing team wants to email customers who have rented more films than the average customer. Return: customer id, full name, email and number of rentals, sorted by rentals descending.
Answer with a single SQL query.
- 2
Store Revenue. For each store, show the total number of rentals and total revenue (sum of payments). Order by revenue descending.
Answer with a single SQL query.
- 3
Most-Featured Actors Rented. A store manager wants to identify customers who have rented at least one film starring the most-featured actor (the actor who appears in the most films). Return: distinct customer id and name.
Answer with a single SQL query.
- 4
Similar Replacement Cost. Write an SQL query that lists pairs of films that have the same replacement cost. For each pair, show Film 1 title, Film 2 title and the shared replacement cost. Every pair of films should appear only once.