SQL Music Store Analysis

This project is a set of SQL queries written to analyze the Chinook sample database. The queries answer key business questions about top customers, popular genres, and customer locations.

Tools Used SQL SQLite (using the SQLiteOnline.com platform)

Business Questions & Queries

This project answers the following questions. The full SQL script can be found in the analysis.sql file.

1. Who are the top 10 highest-spending customers? Purpose: To identify high-value customers for marketing and loyalty programs. Skills: JOIN, GROUP BY, SUM(), ORDER BY, LIMIT

2. Which 5 countries have the most customers? Purpose:To find the largest markets for potential expansion or marketing campaigns. Skills: GROUP BY, COUNT(), ORDER BY, LIMIT

3. What are the top 5 best-selling music genres? Purpose: To inform inventory and purchasing decisions. Skills: Multiple JOINs, GROUP BY, SUM(), ORDER BY, LIMIT