Average suggested edit rejection rate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached