% of edits reviewed by post owners

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(COALESCE(ApprovalDate, RejectionDate))
    AS 'Number of reviewed edits',
  COUNT(sev.Id)
    AS 'Number of reviews by post owners',
  100.0 * COUNT(sev.Id) / COUNT(COALESCE(ApprovalDate, RejectionDate))
    AS '% of edits reviewed by post owners'
  FROM SuggestedEdits AS se
  INNER JOIN Posts AS p
    ON p.Id = se.PostId
  LEFT OUTER JOIN SuggestedEditVotes AS sev
    ON sev.SuggestedEditId = se.Id
   AND p.OwnerUserId = sev.UserId

Enter Parameters

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