0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 25 anonymous

created nov 14 12 Max Shmelev