Top Users by Location and Technology

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.

Stack Overflow

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 * from (
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('%Canberra%'))
  join Posts Questions on Posts.ParentId=Questions.Id
  where Questions.Tags like '%javascript%' or Questions.Tags like '%javascript%'
  group by Users.Id
) q where [Total Reputation] >= 1000;

Enter Parameters

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