Top 100 users with most gold badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100 b.userid, u.displayname, count(*) as gold
from badges b
inner join users u on u.id = b.userid
where name in ('Socratic', 'Stellar Question', 'Great Question', 'Famous Question', 'Illuminator', 'Great Answer', 'Populist', 'Reversal', 'Unsung Hero', 'Fanatic', 'Legendary', 'Marshal', 'Constable', 'Sheriff', 'Steward', 'Copy Editor', 'Electorate', 'Publicist')
group by b.userid, u.displayname
order by gold desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results