0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

with GoldBadgeCounts as (
  select
    u.Id as UserId,
    (
      select count(*) from Badges b
      where b.UserId = u.Id
      and b.Class = 1
    ) as GoldCount
  from Users u
)

select top 1000
  Rank() over (order by GoldCount desc),
  UserId as [User Link],
  GoldCount as [Gold Badges]
from GoldBadgeCounts
order by GoldCount desc

fork query

edited aug 16 17 anonymous

created apr 3 12 Mark Hurd