PS3

  1. 1
    Question reconstructed from the student submission (no question sheet in the source).

    Write a query that returns the title and average rental rate of films longer than 120 minutes whose average rental rate is above 3.5, ordered by average rental rate from highest to lowest, limited to 5 rows.

  2. 2
    Question reconstructed from the student submission (no question sheet in the source).

    Write a query that returns each city and the total amount paid by its residents, ordered by that total from highest to lowest, limited to 5 rows.

  3. 3
    Question reconstructed from the student submission (no question sheet in the source).

    Write a query that returns each film and the number of distinct customers who rented it, ordered by that number from highest to lowest, limited to 5 rows.

  4. 4
    Question reconstructed from the student submission (no question sheet in the source).

    Write a query that returns each staff member's full name, their store, and the number of rentals they processed, ordered by that number from highest to lowest.