StackOverflow users with the most badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

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

SELECT 
  u.Id,
  u.DisplayName,
  COUNT(DISTINCT b.Name) AS DistinctBadges,
  COUNT(b.Id) AS TotalBadges
FROM Badges b
JOIN Users u
ON u.Id = b.UserId
GROUP BY u.Id, u.DisplayName
ORDER BY DistinctBadges DESC

Enter Parameters

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