This beginner-friendly project explores a digital music store database using SQL. The goal is to help the store understand business performance and customer behavior by answering practical questions through query analysis.
To analyze the Music Store playlist database and uncover business insights using structured SQL queries. This includes identifying best-selling tracks, understanding customer preferences, and exploring genre popularity.
- SQL (PostgreSQL)
- PgAdmin4
Here is the entity-relationship diagram used for understanding table relationships:
The database consists of several tables including:
customers– customer demographics and locationinvoices– purchase historyinvoice_items– details of purchased trackstracks,albums,artists– song metadatagenres,media_types– music classification
- Top-selling tracks and artists
- Revenue by country and customer
- Most popular genres
- Customer behavior and spending patterns