Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT TOP(100) u.DisplayName , [Count of Badges] = COUNT(b.id) , [Rank] = RANK() OVER (ORDER BY COUNT(b.id) DESC) FROM Users u INNER JOIN Badges b ON u.id = b.UserId WHERE b.TagBased = 1 GROUP BY u.DisplayName ORDER BY COUNT(b.id) DESC;