Rank Artists by Album Count

Create a leaderboard of artists ranked by how many albums they've released. Artists with the same number of albums should have the same rank.

Write a SQL query that ranks artists by their album count, handling ties appropriately.

Schema: Artist

Schema: Album

Requirements:

• Count albums per artist
• Use RANK() to assign rankings (same count = same rank)
• Return ArtistName, AlbumCount, and ArtistRank
• Order by rank ascending, then ArtistName ascending to break ties
• Show top 15 artists

Note on RANK vs DENSE_RANK:

• RANK(): 1, 2, 2, 4 (skips numbers after ties)
• DENSE_RANK(): 1, 2, 2, 3 (no gaps after ties)