0

Please login or register to vote for this query.

(click on this box to dismiss)

Find users by tag score and location

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- Skill search
-- Find users by tag score and location
with People as (
  select
    Users.Id,-- as [User Link],
    count(*) as Tier
  from
    Users
    inner join Badges on Badges.UserId = Users.Id
  where
    Name like 'c++' and Location like '%New York%'
  group by
    Users.Id
)
select
  DisplayName,
  Location
from
  People
  inner join Users on Users.Id = People.Id
order by
  Tier desc

view current version

edited jan 16 11

created jan 16 11 chrisaycock