Scribd
Upload
24 views15 pages

sql project

The SQL project analyzes a digital music store database to provide insights on geographical growth, purchase power, revenue, genre performance, and band popularity. It includes various SQL queries categorized by difficulty levels, addressing specific questions about employees, invoices, customers, and music genres. The analysis aims to offer actionable recommendations to enhance business growth and performance.

Uploaded by

Rupesh Varshney
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
24 views15 pages

sql project

The SQL project analyzes a digital music store database to provide insights on geographical growth, purchase power, revenue, genre performance, and band popularity. It includes various SQL queries categorized by difficulty levels, addressing specific questions about employees, invoices, customers, and music genres. The analysis aims to offer actionable recommendations to enhance business growth and performance.

Uploaded by

Rupesh Varshney
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 15

SQL Project

Music
Store Analysis
- Parag Uchbagle
Objective
● The project aims to analyze a digital music store database using SQL,
providing stakeholders with valuable insights for decision-making.

● Through SQL queries, it addresses questions regarding geographical


growth, purchase power, revenue, genre performance, and music
band popularity.

● The analysis offers actionable recommendations to drive business


growth and optimize performance.
Database Schema
Level Of Queries

EASY MODERATE HARD


Includes: Includes: Inclludes:
Select , Group by , Joins, Order by, CTE(Common table
Order By, Limit, Group by, Limits Expression)
Desc/ Asc
Easy
• Question : 1. Who is the senior most employee based on job title?

Query Output

• Answer : Senior General Manager Madan Mohan


Easy
• Question :2. Which countries have the most Invoices?

Output
Query

• Answer : USA have the most invoices


Easy
• Question :3. What are top values of total invoice and from which country?

Query Output

• Answer : France with total sum of 23.7


Easy
• Question : 4. Which city has the best customers? We would like to throw a
promotional Music Festival in the city we made the most money. Write a
query that returns one city that has the highest sum of invoice totals. Return
both the city name & sum of all invoice totals
• Output
• Query

• Answer : From customers of from progue store made


most of the money
Easy
• Question : 5. Who is the best customer? The customer who has spent the
most money will be declared the best customer. Write a query that returns
the person who has spent the most money c

Query Output

• Answer : madhav who had spent $144.54 is the best


customer
Moderate
• Question :1. Write query to return the email, first name, last name, &
Genre of all Rock Music listeners. Return your list ordered
alphabetically by email starting with A
Moderate
• Question : 2. Let's invite the artists who have written the most rock
music in our dataset. Write a query that returns the Artist name and
total track count of the top 10 rock bands
Moderate
• Question :3. Return all the track names that have a song length
longer than the average song length. Return the Name and
Milliseconds for each track. Order by the song length with the
longest songs listed first
Advance
• Question1. Find how much amount spent by each customer on
artists? Write a query to return customer name, artist name and
total spent
Query Output
Advance
• Question :2. We want to find out the most popular music Genre for
each country. We determine the most popular genre as the genre
with the highest amount of purchases. Write a query that returns
each country along with the top Genre. For countries where the
maximum number of purchases is shared return all Genres
Output
Query
—Thankyou

[email protected]

You might also like