2.Open your MySQL shell or MySQL Workbench. 3.Run in order: . mysql -u root -p < schema/create_database.sql . mysql -u root -p ecommerce_db < schema/create_tables.sql . mysql -u root -p ecommerce_db < ...

Below are the query prompts I use to practice joins, grouping, and window functions on the Chinook sample database. Each item is a small, interview-style task.