The Online Music Store Analysis project is designed to demonstrate SQL concepts by analyzing a dataset from an online music store.
The project explores various aspects of the store's operations, including employees, customers, invoices, genres, tracks, and artists.
The project includes SQL queries to extract meaningful insights from the dataset.
Some example queries include:
1.Senior Most Employee by Job Title.
2.City with the Best Customers.
3.Top Countries by Number of Invoice.
4.Emails, First Names, Last Names, and Genres of Rock Music Listeners.
5.Tracks Longer Than Average.
1. PostgreSQL
2. PgAdmin4
Author - Akshita singh