gold medals by city

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

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

select top 500 u.location, u.displayname, count(*) as gold
from badges b
inner join users u on u.id = b.userid


where name in ( 'Inquisitive'
, 'Favorite Question'
, 'Good Question'
, 'Notable Question'
, 'Enlightened'
, 'Refiner'
, 'Generalist'
, 'Guru'
, 'Good Answer'
, 'Necromancer'
, 'Tenacious'
, 'Constituent'
, 'Pundit'
, 'Enthusiast'
, 'Epic'
, 'Beta'
, 'Convention'
, 'Outspoken'
, 'Yearling'
, 'Deputy'
, 'Civic Duty'
, 'Reviewer'
, 'Strunk & White'
, 'Archaeologist'
, 'Sportsmanship'
, 'Research Assistant'
, 'Taxonomist'
, 'Booster'
) 
and u.location LIKE ('%##City##%')
group by b.userid, u.displayname, u.location
order by gold desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results