Lab | SQL Queries 4
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
- Get film ratings.
- Get release years.
- Get all films with ARMAGEDDON in the title.
- Get all films with APOLLO in the title
- Get all films which title ends with APOLLO.
- Get all films with word DATE in the title.
- Get 10 films with the longest title.
- Get 10 the longest films.
- How many films include Behind the Scenes content?
- List films ordered by release year and title in alphabetical order.