🎵 SQL Music Store Analysis

📌 Project Overview

This project focuses on analyzing a digital music store database using SQL. The objective of this project is to extract meaningful business insights from customer purchases, invoices, music tracks, artists, albums, and genres.

The analysis helps understand customer behavior, sales performance, popular music genres, top artists, and revenue trends using advanced SQL queries.

---

🛠️ Tools & Technologies Used

• PostgreSQL
• pgAdmin 4
• SQL
• Relational Database Management System (RDBMS)

---

📂 Database Schema

The database consists of multiple connected tables:

• Customer
• Invoice
• InvoiceLine
• Track
• Album
• Artist
• Genre
• Employee
• Playlist

The tables are connected using primary and foreign key relationships.

---

🔍 Key Business Questions Solved

1. Customer Spending Analysis

Find how much amount each customer spent on different artists.

2. Popular Music Genre Analysis

Identify the most popular music genre for each country based on the number of purchases.

3. Revenue Analysis

Analyze total revenue generated from music purchases.

4. Customer Behavior Analysis

Understand customer purchasing patterns across different countries.

5. Artist Performance Analysis

Identify top-performing artists based on sales.

---

🧠 SQL Concepts Used

• SELECT Statements
• Filtering Data
• Aggregate Functions
• GROUP BY
• ORDER BY
• JOINS
  • INNER JOIN
  • Multiple Table Joins
• Subqueries
• Common Table Expressions (CTE)
• Window Functions
• Data Analysis Queries