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.