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