0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT u.*
FROM Users u
JOIN Badges b1 ON u.Id = b1.UserId AND b1.Name = 'Civic Duty'
JOIN Badges b2 ON u.Id = b2.UserId AND b2.Name = 'Strunk & White'
JOIN Badges b3 ON u.Id = b3.UserId AND b3.Name = 'Deputy'
JOIN Badges b4 ON u.Id = b4.UserId AND b4.Name = 'Convention'
WHERE u.Reputation >= 3000
order by u.Reputation desc;

fork query

edited feb 29 anonymous

created feb 27 Fastnlight