Music Store Analysis
A SQL analysis project that turns a relational digital-music-store database into answers about customer value, sales geography, artist demand, and genre preferences.
Translate business questions into precise, repeatable queries across connected store tables.
Progress from sorting and aggregation to multi-table joins, CTEs, and country-level rankings with window functions.
Revenue by city, highest-value customers, top rock artists, and the most purchased genre by country.