Users with high proportion of Au and Ag badges

0

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 (
  select 
    userid, 
    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 (users.id = data.userid)
where (gold > bronze) and (gold + silver + bronze > 2)
order by reputation desc, gold desc, silver desc, bronze desc

Enter Parameters

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