In this lab, you will be using the Sakila database of movie rentals. You can follow the steps listed here to get the data locally: Sakila sample database - installation.
The database is structured as follows:
- Show tables in the database.
- Explore tables. (select everything from each table)
- Select one column from a table. Get film titles.
- Select one column from a table and alias it. Get languages.
- How many stores does the company have? How many employees? which are their names?