Total Badges User Leaderboard (w/ Type Breakdowns)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Total badges per user, with gold/ silver/ bronze total breakdowns.

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT TOP 100
  Count(CASE WHEN Class = 1 THEN 1 END) AS 'Gold',
  Count(CASE WHEN Class = 2 THEN 1 END) AS 'Silver',
  Count(CASE WHEN Class = 3 THEN 1 END) AS 'Bronze',
  Count(Id) AS 'Total',
  UserId AS [User Link]
FROM Badges
GROUP BY UserId
ORDER BY [Total] DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results