SELECT Badges.UserId,Users.DisplayName,Users.Reputation F...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writing Meta

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 AND Users.Reputation < 3000
GROUP BY Badges.UserId,Users.DisplayName,Users.Reputation
HAVING COUNT(DISTINCT Badges.Name) = 2
ORDER BY Badges.UserId;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results