StackOverflow users with the most badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

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 meta site
loading Hold tight while we fetch your results