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 for computer enthusiasts and power users

-- 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 'Ja%' and Location like '%ndia%'
  group by
    Users.Id
)
select
  DisplayName [User Link],
  Location
from
  People
  inner join Users on Users.Id = People.Id
order by
  Tier desc

fork query

edited jul 27 17 anonymous

created jan 16 11 chrisaycock