Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
SELECT u.DisplayName, COUNT(b.Id) AS BadgeCount FROM Badges b JOIN Users u ON b.UserId = u.Id GROUP BY u.DisplayName ORDER BY BadgeCount DESC;