Note: SEDE currently does not have a good way to determine if a user is a moderator.
Q&A for scientists using computers to solve scientific problems
-- 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