View users who have earned the most badges of a given name.
Q&A for professional and enthusiast programmers
select top 1000
UserId as [User Link],
count(*) as [Badge Count]
where Name = ##BadgeName:string?Revival##
-- BadgeName: Badge Name (case sensitive): "Show users with the highest number of this badge."
group by UserId
order by [Badge Count] desc;