All sample databasesChinook
Music retail · chinook.demodb.dev
Chinook
sample database.
A digital music store database for learning SQL, joins, and data tooling.
-- Artists by track count
SELECT Artist.Name, COUNT(Track.TrackId) AS Tracks
11 tables · 0 views · 15,607 rows
-- 3 high-confidence cross-database table matches
11tables
0views
15,607table rows
Schema at a glance
Browse the recordsets.
table Album Albums released by an artist. 3 columns · 1 links · 347 rows table Artist Artists represented in the music catalogue. 2 columns · 0 links · 275 rows table Customer Customers who purchase music from the store. 13 columns · 1 links · 59 rows · 1 matches in other samples table Employee Store employees and their reporting relationships. 15 columns · 1 links · 8 rows · 1 matches in other samples table Genre Music genres assigned to tracks. 2 columns · 0 links · 25 rows table Invoice Billing invoices issued to customers for music purchases. 9 columns · 1 links · 412 rows table InvoiceLine Individual tracks and quantities on an invoice. 5 columns · 2 links · 2,240 rows · 1 matches in other samples table MediaType File and encoding types used by tracks. 2 columns · 0 links · 5 rows table Playlist Named collections of tracks. 2 columns · 0 links · 18 rows
Downloads
Use this fixture
where you work.
Available files are generated from the provider’s pinned database contract. Pick a complete database or a single table.