0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited apr 1 13 anonymous

created mar 21 13 hims056