#96

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.

nameconcert_count
Bruce Springsteen5
David Bowie2
Mick Jagger2

Your query result will appear here