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.

Engineering

Q&A for professionals and students of engineering

-- 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 ('%United States%'))
  join Posts Questions on Posts.ParentId=Questions.Id
  where Questions.Tags like '%kafka%' or Questions.Tags like '%<Hive>%'
  group by Users.Id
  order by [Technology Reputation] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results