0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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;

fork query

edited feb 29 anonymous

created feb 27 Fastnlight