Q&A about the site for active researchers, academics and students of physics
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;