I very infrequently use SQL. I need more experience, so I have created a data explorer query to find those users with most of any particular badge (have to edit the query itself right now to alter it). I like following best practices, so please feel free to nit-pick and really do this right (indentation, capitalization, everything).
I have commented code that I cannot get to work (I would like it to work by user input), I hope my intent is quite obvious.
--declare @BadgeName nvarchar(50) = ##BadgeName:string## --declare @MyTop int = ##MyTop:int## select -- top @MyTop top 100 Badges.UserId as [User Link], Users.Reputation, --Badges.Name, count(Badges.Id) as NumberOfBadges from Badges inner join Users On Users.Id=Badges.UserId where -- Badges.Name = @BadgeName and Badges.Name = 'Great Answer' and Users.Reputation > 10000 group by Badges.UserId, Users.Reputation order by NumberOfBadges desc
Here's the actual query if you want to run it: