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 scientific skepticism

-- Skill search
-- Find users by tag score and location

-- select * from users where reputation>1000 and location like '%New York%' order by displayname;

-- select * from users where id = 478288;

-- table of all questions and answers
--select * from posts where owneruserid = 478288;

-- table of questions and their tags
--select * from posttags where postid=4307240;

--select Id from Tags where TagName like 'c++';

--select * from Votes;

--select * from Badges where Name like 'c++';
select
    DisplayName,
--    Reputation,
    count(*) as Tier
--    Location
from
    Users
    inner join Badges on Badges.UserId = Users.Id
where
    Name like 'c++' and Location like '%New York%'
group by
    DisplayName
order by
    Tier desc

fork query

created jan 16 11 chrisaycock