PS4

  1. 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. 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. 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. 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.