Users with high proportion of Au and Ag badges


Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

select top 2048 userid as [User Link], reputation, bronze, silver, gold
from (
    sum(case when class = 3 then 1 else 0 end) as bronze, 
    sum(case when class = 2 then 1 else 0 end) as silver, 
    sum(case when class = 1 then 1 else 0 end) as gold
  from badges
  group by userid
  ) data JOIN (select id, reputation from users) users ON ( = data.userid)
where (gold > bronze) and (gold + silver + bronze > 2)
order by reputation desc, gold desc, silver desc, bronze desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results