Practice intermediate SQL question: Number Tracks Within Albums

Solve this interactive intermediate question online in our browser coding environment.

Number Tracks Within Albums

intermediate~6 min25 pts

Problem

You need to assign a sequential number to each track within its album, ordered by the track's position (TrackId). This is useful for creating numbered playlists.

Write a SQL query that assigns a row number to each track within its album, ordered by TrackId.

Schema: Track

Column	Type
TrackId	INTEGER (Primary Key)
Name	TEXT
AlbumId	INTEGER (Foreign Key → Album.AlbumId)
MediaTypeId	INTEGER (Foreign Key)
GenreId	INTEGER (Foreign Key → Genre.GenreId)
Composer	TEXT
Milliseconds	INTEGER
Bytes	INTEGER
UnitPrice	NUMERIC(10,2)

Schema: Album

Column	Type
AlbumId	INTEGER (Primary Key)
Title	TEXT
ArtistId	INTEGER (Foreign Key → Artist.ArtistId)

Requirements:

Use ROW_NUMBER() window function
Partition by AlbumId
Order by TrackId within each partition
Return AlbumId, track Name, and the row number as "TrackNumber"
Limit to first 20 rows for display

Window Function Syntax:

ROW_NUMBER() OVER (PARTITION BY column ORDER BY column)

Window Functions ROW_NUMBER PARTITION BY

📊

📊 View Question Telemetry & Insights

Failure rate, silent bug autopsy & optimal query construction

Inspect →

Master SQL & Data Analytics

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

Explore the 12-Week Data Analyst Career Track