Chinook SQL Analysis

Goal of Project

Analyzing a relational music shop Database with SQL and having my first SQL experience while doing it.

Used Concepts

• SELECT AS FROM
• WHERE
• ORDER BY
• GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN
• LIMIT
• Subqueries
• Aggregationes

Asked Questions (Examples)

• Top Customer by Revenue
• Revenue by Country
• Revenue by Genre
• Revenue by Artist
• Consumer Patterns
• ...

Insights

• For Coding Insights see 01_data_exploration - 05_key_moments.sql
• Everyone except one Customer bought the same amount of Tracks (Looking at you Puja!)
• With 2328.6$ total Revenue in 5 years, this company needs a new PR team quickly
• Iron Maiden produced a lot of music
• Jamiroquai is realy versatile and maybe I should give it another try after 15 years