In this lab, you will be using the Sakila database of movie rentals. You have been using this database for a couple labs already, but if you need to get the data again, refer to the official installation link.
The database is structured as follows:
- Inspect the database structure and find the best-fitting table to analyse for the next task.
- Use the RANK() and the table of your choice rank films by length (filter out the rows that have nulls or 0s in length column). In your output, only select the columns title, length, and the rank.
- Build on top of the previous query and rank films by length within the
rating
category (filter out the rows that have nulls or 0s in length column). In your output, only select the columns title, length, rating and the rank. - How many films are there for each of the categories? Inspect the database structure and use appropriate join to write this query.
- Which actor has appeared in the most films?
- Most active customer (the customer that has rented the most number of films)
Bonus: Which is the most rented film? The answer is Bucket Brotherhood This query might require using more than one join statement. Give it a try. We will talk about queries with multiple join statements later in the lessons.