0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

WITH b AS (SELECT UserId, Name
  FROM Badges
  WHERE Name IN ('Civic Duty', 'Cleanup', 'Deputy', 'Electorate', 'Marshal', 'Reviewer', 'Sportsmanship', 'Steward')
  GROUP BY UserId, Name)
SELECT UserId AS [User Link], COUNT(*) AS 'Number of moderation badges'
  FROM b
  GROUP BY UserId
  ORDER BY COUNT(*) DESC

fork query

created nov 11 Glorfindel