SQL Music Databases

This project focuses on analyzing a music playlist database using SQL to help the store understand its business growth.

We've written queries to answer specific questions.

Easy:

Find the most senior employee by job title.

List countries with the highest number of invoices.

Identify the top 3 invoice totals.

Determine the city with the highest total invoice amount for a Music Festival promotion.

Find the customer who spent the most money. Medium:

Get the email, first name, last name, and Genre of all Rock Music listeners, ordered alphabetically by email.

List the top 10 rock bands by the number of tracks they've written.

Display track names and lengths longer than the average, ordered by length. Advanced:

Show the total amount spent by each customer on artists.

Identify the most popular music Genre for each country, accounting for shared top Genres.

Determine the top-spending customer for each country, considering shared top amounts spent.

Postgre SQL