Accepted vs. Rejected edits per month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

SELECT
  DATEPART(yyyy, COALESCE(ApprovalDate, RejectionDate)) AS yyyy,
  DATEPART(mm, COALESCE(ApprovalDate, RejectionDate)) AS mm,
  COUNT(ApprovalDate) AS ApprovalCount,
  COUNT(RejectionDate) AS RejectionCount
FROM SuggestedEdits
GROUP BY
  DATEPART(yyyy, COALESCE(ApprovalDate, RejectionDate)),
  DATEPART(mm, COALESCE(ApprovalDate, RejectionDate))

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results