Q&A for programmers
SELECT COUNT(*) AS TOTAL , SUM(CASE WHEN ApprovalDate IS NOT NULL THEN 1 ELSE 0 END) AS Total_Approved , SUM(CASE WHEN RejectionDate IS NOT NULL THEN 1 ELSE 0 END) AS Total_Rejected , SUM(CASE WHEN ApprovalDate IS NOT NULL THEN 1 ELSE 0 END) * 100 / COUNT(*) AS Average_Approved , SUM(CASE WHEN RejectionDate IS NOT NULL THEN 1 ELSE 0 END) * 100 / COUNT(*) AS Average_Rejected FROM SuggestedEdits;