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:
- Select all the actors with the first name ‘Scarlett’.
- Select all the actors with the last name ‘Johansson’.
- How many films (movies) are available for rent?
- How many films have been rented?
- What is the shortest and longest rental period?
- What are the shortest and longest movie duration? Name the values max_duration and min_duration.
- What's the average movie duration?
- What's the average movie duration expressed in format (hours, minutes)?
- How many movies longer than 3 hours?
- Get the name and email formatted. Example: Mary SMITH - mary.smith@sakilacustomer.org.
- What's the length of the longest film title?