Users by Location

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

-- Skill search
-- Find users by tag score and location
with People as (
  select
    Users.Id,-- as [User Link],
    count(*) as Tier
  from
    Users
  where
    Location like '%Moncton%'
  group by
    Users.Id
)
select
  DisplayName [User Link],
  Location,
  Users.Reputation
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