Last updated Nov 17, 2024

• DROP the tables from your previous assignment(s), if necessary
• Run the following script to populate your database -> MagicStoreScript (github.com)
• Magic Store Database Overview: SQL - W3 Magic Store Database Overview

• SQL - W10 Advanced Querying - Introduction
• Next: SQL - W10 Advanced Querying - Aggregate Functions
• SQL - W10 Advanced Querying - Column Aliasing
• SQL - W10 Advanced Querying - Calculating Values
• SQL - W10 Advanced Querying - Northwind Database
• SQL - W10 Advanced Querying - GROUP BY
• SQL - W10 Advanced Querying - Data Analytics with GROUP BY
• SQL - W10 Advanced Querying and Data Analytics Assignment