Fans by Concert Count
The band's loyalty program is compiling its super-fan ranking — those who've attended the most concerts. For every fan with at least one attended concert output the name and the attended-concert count. Sort by count descending, then by name ascending on ties.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| name | concert_count |
|---|---|
| Bruce Springsteen | 5 |
| David Bowie | 2 |
| Mick Jagger | 2 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in