Chinook SQL Analysis

A small SQL project using the Chinook sample database with MySQL.

I used this project to practice querying relational data and explore customer behavior, sales, tracks, artists, genres, and monthly revenue.

Questions explored

• Sales by country
• Top customers
• Best-selling tracks and genres
• Sales by support representative
• Monthly sales trends
• Basic data quality checks

Tools

• MySQL
• MySQL Workbench

How to use

1. Import data/Chinook_MySql.sql into MySQL.
2. Select the chinook database.
3. Run the nine SQL files in queries/ in numeric order.

Dataset: Chinook Database

Schema

The checked-in schema diagram is docs/Chinook_ERD.png. This remains a practice project using sample data.