🎻Project Description:
This project uses SQL to analyze the dataset of an online music store.
The objective of the project is to gain valuable insights into the store's operations, Customer Segmentation, trends ,artist effectiveness, artist growth, customer interest and money spent by customer.
The goal of the project is to answer a set of questions about the store's business performance and help in its growth by making better decisions.
🎻Tool Used:
MySQL(Queries, Subqueries, Joins, CTE, Window functions, Aggregate functions)using this I have analyze data.
🎻Tables Used:
album
artist
customer
employee
invoice
genre
invoice_line
media_type
playlist
playlist_track
track
🎻Queries of the Project:
Q1: Who is the senior most employee based on job title?
Q2: Which countries have the most Invoices?
Q3: What are top 3 values of total invoice?
Q4: Which city has the best customers? We would like to throw a promotional Music Festival in the city we made the most money.
Q5: Who is the best customer? The customer who has spent the most money will be declared the best customer.
Q6: Write query to return the email, first name, last name, & Genre of all Rock Music listeners.
Q7: Let's invite the artists who have written the most rock music in our dataset.
Q8: Return all the track names that have a song length longer than the average song length.
Q9: Find how much amount spent by each customer on artists? Write a query to return customer name, artist name and total spent
Q10: We want to find out the most popular music Genre for each country.
Q11: Write a query that determines the customer that has spent the most on music for each country.