SELECT u.DisplayName, COUNT(b.Name) AS NumBadges FROM Use...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Retrocomputing Meta

Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear

SELECT u.DisplayName, COUNT(b.Name) AS NumBadges
FROM Users u
JOIN BADGES b 
ON u.Id = b.UserId
GROUP BY u.Id, u.DisplayName
ORDER BY NumBadges DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results