Lab | SQL Queries 8
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:
Instructions
- 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.
- 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 in the category table. 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.