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;