Q&A for meta-discussion of the Stack Exchange family of Q&A websites
SELECT TOP 10 u.DisplayName, COUNT(b.Id) AS TotalBadges FROM Badges b JOIN Users u ON b.UserId = u.Id GROUP BY u.DisplayName ORDER BY TotalBadges DESC