Skip to content

Latest commit

 

History

History
16 lines (12 loc) · 537 Bytes

File metadata and controls

16 lines (12 loc) · 537 Bytes

I've analyzed the dataset using SQL to assist the Music Store in gaining insights into its business growth by addressing basic inquiries.

Database and Tools

  • Postgre SQL
  • PgAdmin4

Concepts used for this project

  • Aggregation functions like sum, average, count
  • Window functions
  • sub-queries
  • Common Table Expression(CTEs)
  • Joins: Self-join,Right join, Inner join

Schema- Music Store Database
MusicDatabaseSchema