MySQL with Sakila database

Let's query some data from the Sakila sample database using MySQL workbench! We will use subqueries, statements including JOIN, CREATE VIEW, GROUP BY, ORDER BY, WHERE, LIMIT, and mathematical functions such as SUM() and COUNT().

Resources

• Sakila database

Getting started

• Install MySQL workbench
• Initiate and run the SQL server
• Download the Sakila database

Run the SQL script

Download the SQL file from this repository and open in MySQL workbench. Be sure to load the Sakila database and update to the Schema. Have fun!

Author

Ying Li