music_store_analysis_postgreSQL

It is a postgreSQL project to find some insights from store database it answers important questions to enhance the business.

Music Store Database - Schema

Database and Tool Used

• Postgre SQL
• PgAdmin4

Question found

Senior most employee

Top 3 invoices

Countries have most invoives

City has the best customers (we can organize some events and fests to mnake more money in this city)

Best Customer

Amount spent by each customer or artists

....... and many more.