Recap exercise

In the following dataset, run sakila-scheme first, sakila-data after:

Fronter: ITA23 - PBA IT-Arkitektur 1. Semester > Ressourcer > Dataforståelse & databasedesign > 06 Data Analysis 2 - SubQueries & Regular Expressions

Reverse engineer the dataset and get an overview. (You will need it)

Exercises

  1. Retrieve all customer names along with their email addresses.

  2. List the names and phone numbers of all customers whose last name starts with 'S'.

  3. Find the top 10 customers who have spent the most on rentals.

  4. Retrieve the films that are in the "Family" category and have a length of less than 90 minutes.

  5. Retrieve the titles of films that were rented in February.

  6. Find the five most rented films.

  7. Find the number of films available in the store for each rating category.

Advanced (Optional)

  1. List the films that are available for rent, but haven't been rented yet (Hint: movies that are IN or NOT IN something?)

  2. Find the customers who have rented more than 5 films in 2005.

  3. List the top 5 actors who have appeared in the most films.

  4. Find the average rental duration for each film category.

  5. Retrieve the names and total revenue of the top 10 customers who have generated the most revenue for the store.

Previous10-post-request.mdNextDatabase Design

Last updated