Skip to content

Latest commit

 

History

History
24 lines (14 loc) · 783 Bytes

class_11.md

File metadata and controls

24 lines (14 loc) · 783 Bytes

Exercises

  1. Find all the film titles that are not in the inventory.

  2. Find all the films that are in the inventory but were never rented.

    • Show title and inventory_id.
    • This exercise is complicated.
    • hint: use sub-queries in FROM and in WHERE or use left join and ask if one of the fields is null

  3. Generate a report with:

    • customer (first, last) name, store id, film title,
    • when the film was rented and returned for each of these customers
    • order by store_id, customer last_name

  4. Show sales per store (money of rented films)

    • show store's city, country, manager info and total sales (money)
    • (optional) Use concat to show city and country and manager first and last name

  5. Which actor has appeared in the most films?