Note: SEDE currently does not have a good way to determine if a user is a moderator.
Q&A for professional and enthusiast 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] --, b.Name , CASE 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 AND (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