Compute each artist's total track count (across all their albums) and rank artists by that count, highest first, using RANK() so ties share a rank.
Return ArtistId, Name, TrackCount, and TrackCountRank, ordered by rank then Name.
| Column | Type |
|---|---|
| ArtistId | INTEGER (Primary Key) |
| Name | TEXT |
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.
Run your code to see the result here.