Suggested Edit acceptance percentage, by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

The percentage of suggested edits that each user on the site accepts out of their total reviews. Users with less than 25 reviews don't qualify.

Network Engineering

Q&A for network engineers

SELECT * FROM (
SELECT
  UserId AS [User Link],
  SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS [Accepts],
  SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS [Rejects],
  COUNT(*) AS [Total Reviews],
  (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS DECIMAL) / COUNT(*)) * 100 
    AS [Accept percentage]
FROM SuggestedEditVotes
WHERE UserId <> -1 -- Ignore the community user
GROUP BY UserId
--HAVING COUNT(*) >= 25 -- Ignore users with less than 25 reviews
) A
--ORDER BY (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS DECIMAL) / COUNT(*)) DESC,
--SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) DESC

Enter Parameters

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