This project analyzes the Chinook Database, which simulates a digital music store. The analysis covers sales trends, customer insights, and revenue breakdowns using SQL queries.
✔ Total Revenue: $2,328.60
✔ Top-Selling Album: Minha Historia by Chico Buarque (27 sales)
✔ Highest Revenue Region: USA ($523.06)
✔ Peak Sales Month: January 2009 ($35.64)
✔ Top Customer: Helena Holý (Spent $49.62)
- Database: Chinook SQLite
- Tables Used:
Customer,Invoice,Track,Artist,Album,InvoiceLine - Queries Used: Joins, Aggregations, CTEs
Full SQL queries are available in Chinook.sql.