Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
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