Music Store Data Analysis

Music Store Data Analysis: This project examines the dataset of a music store using SQL to help the store understand its business growth and performance through various queries and insights.

Key Features:

  • User-interactive presentation available in the repository.
  • Identify the senior-most employee by name and job title.
  • Determine which countries generate the most invoices.
  • Find the top three highest invoice totals.
  • Identify the city with the highest sum of invoice totals to host a promotional Music Festival.
  • Determine the customer who has spent the most money in the store.
  • Identify the most popular music genre for each country based on purchases, including ties for the highest purchase count.
  • Retrieve the first name, last name, email, and genre of all Rock music listeners, ordered alphabetically by email.
  • Find the top 10 artists who have written the most rock tracks, including the artist name and total track count.
  • Return track names and durations for songs longer than the average song length, ordered by duration from longest to shortest.
  • Determine how much each customer has spent on each artist, including the customer name, artist name, and total spent.
  • Identify the top customer by spending for each country, including ties for the highest amount spent.