Database Schema
SQL Queries
Query Results

Project Information

  • Category: Data Analysis
  • Client: Personal Project
  • Project Date: Feb, 2024
  • Project URL: GitHub Repository
  • Tool & Tech: PostgreSQL, PgAdmin4

SQL Project: Music Store Analysis

This project involves analyzing a music store database using PostgreSQL and PgAdmin4. Key queries include:

  • Senior Most Employee by Job Title
  • Countries with Most Invoices
  • Top 3 Values of Total Invoice
  • City with the Best Customers
  • Best Customer
  • Rock Music Listeners
  • Top 10 Rock Bands
  • Tracks Longer Than Average
  • Amount Spent by Each Customer on Artists
  • Most Popular Music Genre for Each Country
  • Top Customer for Each Country

The project provides insights into customer behavior, sales trends, and popular music preferences, offering a comprehensive view of the music store's performance.