3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

declare @BadgeName nvarchar(50) = ##BadgeName:string##;
declare @MyTop int = ##TopUsers:int##;

select
    top(@MyTop)
    Badges.UserId as [User Link],
    Users.Reputation,
    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, Reputation desc

fork query

edited jan 24 16

created feb 6 15 jon.doe12636