Users by number of profile-trackable badges obtained

1

Please login or register to vote for this query.

(click on this box to dismiss)

Total is 47; currently only Stack Overflow has users on the max.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 500
UserId AS [User Link],
COUNT(DISTINCT Name) AS 'Number'
FROM Badges
WHERE Name IN ('Copy Editor', 'Electorate', 'Fanatic', 'Illuminator',
               'Legendary', 'Marshal', 'Socratic')
   OR Name IN ('Archaeologist', 'Civic Duty', 'Deputy', 'Enthusiast', 
               'Epic', 'Inquisitive', 'Necromancer', 'Refiner', 
               'Research Assistant', 'Sportsmanship', 'Strunk & White')
   OR Name IN ('Altruist', 'Autobiographer', 'Benefactor', 'Citizen Patrol', 
               'Cleanup', 'Commentator', 'Critic', 'Curious', 'Custodian', 
               'Disciplined', 'Editor', 'Excavator', 'Explainer', 'Informed', 
               'Investor', 'Mortarboard', 'Organizer', 'Peer Pressure', 
               'Promoter', 'Proofreader', 'Revival', 'Scholar', 
               'Self-Learner', 'Student', 'Suffrage', 'Supporter', 
               'Tag Editor', 'Teacher', 'Vox Populi')
GROUP BY UserId
ORDER BY COUNT(DISTINCT Name) DESC

Enter Parameters

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