0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

-- Credit to https://stackoverflow.com/a/78031362 by Tim Biegeleisen
-- for the code to find all users with those badges
SELECT Badges.UserId,Users.DisplayName,Users.Reputation From Badges
INNER JOIN Users ON Badges.UserId=Users.Id
WHERE Badges.Name IN ('Civic Duty', 'Strunk & White', 'Deputy', 'Convention')
AND Users.Reputation > 500
GROUP BY Badges.UserId,Users.DisplayName,Users.Reputation
HAVING COUNT(DISTINCT Badges.Name) = 2
ORDER BY Badges.UserId;

fork query

created feb 27 anonymous