1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

WITH Raw AS (
  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))
)
SELECT
  DATEFROMPARTS(yyyy, mm, 1) AS Month,
  ApprovalCount,
  RejectionCount
FROM Raw
ORDER BY Month DESC;

fork query

edited jul 18 19

created jul 18 19 peterh - PLEASE DELETE THIS ACCOUNT