Music Store
A small online music shop: artists from five countries, their albums and tracks, and the customers who buy them. Classic business data, perfect for learning how tables link together.
- SELECT and WHERE basics
- Sorting with ORDER BY and LIMIT
- Joining artists → albums → tracks
- Revenue with SUM and GROUP BY
You need to calculate revenue. Show the album title and the total revenue it has generated.
40 challenges across the seven levels
- PKartist_id
- name
- FKcountry
- PKalbum_id
- title
- release_year
- FKartist_id
- PKtrack_id
- title
- duration
- FKalbum_id
- PKgenre_id
- name
- PKcustomer_id
- first_name
- last_name
- PKorder_id
- order_date
- FKcustomer_id
- total_amount
- PKorder_item_no
- FKorder_id
- FKalbum_id
- quantity
- PKcountry_id
- country_name
Plus two link tables, Artists_Genres and Albums_Genres, that connect artists and albums to genres.
View the Music Store schema