Compare each top editor's total edits against the overall average: How much more than average as percentage

SQL

SET @avg_edits = (
    SELECT AVG(totaledits) AS avg_edit
    FROM (
        SELECT 
            r.rev_actor AS actor_id,
            a.actor_name,
            COUNT(r.rev_id) AS totaledits
        FROM 
            revision r
        JOIN 
            actor a ON r.rev_actor = a.actor_id
        WHERE 
            r.rev_timestamp BETWEEN 
                DATE_FORMAT(CURDATE() - INTERVAL 2 MONTH, '%Y-%m-01') AND 
                LAST_DAY(CURDATE()) -- Get the last day of the current month
        GROUP BY 
            r.rev_actor
    ) AS new
);

SELECT 
    a.actor_name, 
    COUNT(r.rev_id) AS total_edits,
    ROUND(((COUNT(r.rev_id) - @avg_edits) / @avg_edits) * 100, 2) AS percentage_above_avg
FROM 
    revision r
JOIN 
    actor a ON r.rev_actor = a.actor_id
WHERE 
    r.rev_timestamp BETWEEN 
        DATE_FORMAT(CURDATE() - INTERVAL 2 MONTH, '%Y-%m-01') AND 
        LAST_DAY(CURDATE()) -- Get the last day of the current month
GROUP BY 
    a.actor_name
ORDER BY 
    total_edits DESC
LIMIT 5;

SQL

Checking query status...