Skill search

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find users by tag score and location

Chess

Q&A for serious players and enthusiasts of chess

-- 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 'python' and DisplayName like '%Kalpesh%'
  group by
    Users.Id
)
select
  DisplayName,
  Location
from
  People
  inner join Users on Users.Id = People.Id
order by
  Tier desc

Enter Parameters

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