The recommendation team wants a leaderboard of the most prolific artists measured by total tracks across all their albums.
| Column | Type |
|---|---|
| ArtistId | INTEGER (PK) |
| Name | TEXT |
| Column | Type |
|---|---|
| AlbumId | INTEGER (PK) |
| Title | TEXT NOT NULL |
| ArtistId | INTEGER (FK → Artist) |
| Column | Type |
|---|---|
| TrackId | INTEGER (PK) |
| Name | TEXT NOT NULL |
| AlbumId | INTEGER (FK → Album) |
| MediaTypeId | INTEGER (FK → MediaType) |
| GenreId | INTEGER (FK → Genre) |
| Composer | TEXT |
| Milliseconds | INTEGER NOT NULL |
| Bytes | INTEGER |
| UnitPrice | NUMERIC(10,2) NOT NULL |
ArtistName and TrackCount per artistReady to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.