This project contains a collection of SQL queries designed to analyze the Chinook Music Store Database. It explores customer behavior, sales performance, genre popularity, artist rankings, and country-wise music trends using advanced SQL techniques.
- Identify top-spending customers and high-revenue cities
- Find the most popular genres, artists, and songs
- Analyze revenue patterns across countries
- Discover rock music listeners and top rock artists
- Compare track lengths and identify above-average songs
- Evaluate purchasing behavior by genre and region
- Analytical Queries (Q1–Q17)
- Views for reusable reporting
- Stored Procedures for year-wise and artist-wise revenue analysis
This file is ideal for SQL learners and analysts who want to practice real-world queries and gain insights from a music store dataset.