In this lab you will continue using the Sakila database of movie rentals.
The ERD is pictured below - not all tables are shown, but many of the key fields you will be using are visible:
-
How many distinct (different) actors' last names are there?
-
In how many different languages where the films originally produced? (Use the column language_id from the film table)
-
How many movies were released with "PG-13" rating?
-
Get 10 the longest movies from 2006.
-
How many days has been the company operating (check DATEDIFF() function)?
-
Show rental info with additional columns month and weekday. Get 20.
-
Add an additional column day_type with values 'weekend' and 'workday' depending on the rental day of the week. Check the CASE function.
-
How many rentals were in the last month of activity?