Users By Number Of Gold Non-Tag Badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

with GoldBadgeCounts as (
  select
    u.Id as UserId,
    (
      select count(*) from Badges b
      where b.UserId = u.Id
      and b.Name in (
        'Copy Editor',
        'Electorate',
        'Famous Question',
        'Fanatic',
        'Great Answer',
        'Great Question',
        'Legendary',
        'Marshal',
        'Populist',
        'Publicist',
        'Reversal',
        'Stellar Question',
        'Unsung Hero'
      )
    ) 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results