Gets a list of most reputed users from a given location.
Q&A about the site for programming puzzle enthusiasts and code golfers
select Users.Id as [User Link], max(Users.Location) as Location, count(*)*10 as [Technology Reputation], max(Users.Reputation) as [Total Reputation] from Votes join Posts on Votes.PostId=Posts.Id join Users on Posts.OwnerUserId=Users.Id and Users.Id in (select Users.Id from Users where lower(location) like lower('%Vienna%')) join Posts Questions on Posts.ParentId=Questions.Id where Questions.Tags like '%typescript%' or Questions.Tags like '%typescript%' and Users.Reputation >= 1000 group by Users.Id order by [Technology Reputation] desc