0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @BadgeName AS NVARCHAR(50) = ##BadgeName:string?Great Answer##;
DECLARE @MyTop AS INT = ##MyTop:int?100##;

SELECT TOP(@MyTop)
    Badges.UserId AS [User Link],
    Users.Reputation,
    @BadgeName,
    COUNT(Badges.Id) AS NumberOfBadges
FROM 
    Badges 
  INNER JOIN 
    Users ON Users.Id=Badges.UserId
WHERE Badges.Name = @BadgeName
  AND Users.Reputation > 10000
GROUP BY 
    Badges.UserId, Users.Reputation
ORDER BY 
    NumberOfBadges DESC

fork query

edited feb 6 15 Brythan

created feb 6 15 jon.doe12636