List of Users in a given location using a given technology. Counts reputation only for votes on answers, ignores questions, comments, or reputation for accepted answers.
Q&A for professional and enthusiast programmers
-- List of Users in a given location using a given technology -- Counts reputation only for votes on answers, ignores questions, comments, or reputation for accepted answers 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 location like ('%Mexico%')) join Posts Questions on Posts.ParentId=Questions.Id where Questions.Tags like '%java%' or Questions.Tags like '%<python>%' group by Users.Id order by [Technology Reputation] desc