4

On a certain SE site, I'm interested in seeing how many people have both of two different badges (Promoter & Tumbleweed).

Is there a way to do this?

7

The following query will return the users who has the Promoter, Tumbleweed badges on a specific site.

SELECT TOP 1000 UserId AS [User Link]
FROM Badges
WHERE Name IN ('Promoter', 'Tumbleweed')
GROUP BY UserId
HAVING COUNT(DISTINCT Name) = 2

Note: Adding TOP 1000 to avoid the timeout issue,

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .