Week 4 Assignment: SQL Joins

Welcome to your first major SQL data analysis assignment! This week, we move beyond single tables and start connecting datasets to uncover deeper business insights.

Learning Objectives

• Connect relational datasets using INNER JOIN and LEFT JOIN.
• Solve business questions by aggregating data across multiple tables.
• Practice data ingestion into your local MySQL instance.

Instructions

1. Setup Your Environment

• Open MySQL Workbench.
• Run the schema.sql script to create your tables.
• Use the Table Data Import Wizard to import the CSV files from the data/ folder:
  1. Import customers.csv into the customers table.
  2. Import orders.csv into the orders table.

2. Complete the Assignment

• Open exercises/joins_assignment.sql.
• Complete the three tasks described in the file.
• Ensure your queries return the exact columns requested.

3. Submit

• Commit and push your changes to your GitHub Classroom repository.
• The automated grading will run and report your status in the "Actions" tab.

Data Schema Reference

• customers: customer_id, name, email, country
• orders: order_id, customer_id, order_date, total_amount