Note: SEDE currently does not have a good way to determine if a user is a moderator.
Q&A for programmers
-- How many moderators have the "Sportsmanship" badge?
-- Note: SEDE currently does not have a good way to determine if a user is a moderator.
SELECT u.Id AS [User Link]
WHEN b.Name IS NULL THEN N'✖ Not sporting'
ELSE N'✔ Sporting'
END AS [Good Sport?]
FROM Users u
LEFT JOIN Badges b
ON ( u.Id = b.UserId
(b.Name IS NULL OR LOWER(b.Name) = 'sportsmanship')
-- List of SO mods. SEDE has no good method for mod detection!
WHERE u.Id IN (105971, 1288, 106224, 50776, 54680, 419, 267, 13531, 396458, 102937, 50049, 1228)
ORDER BY u.DisplayName
Error: looks like you typed in the wrong words - try again