Number of gold badge holders for each tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT b.name tag, count(*) holders
FROM Badges b, Users u
WHERE b.class=1 and b.tagBased = 1 and u.Id=b.UserId 
GROUP BY b.name
ORDER BY holders DESC

Enter Parameters

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