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
actor_id,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%m01') AND
             DATE_FORMAT(CURDATE(),'%Y%m%d')
GROUP BY 
 actor_id) AS new);
SELECT 
    a.actor_name, 
    COUNT(r.rev_id) AS total_edits ,ROUND(((COUNT(r.rev_id)-@avg_edits)/@avg_edits)*100) 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%m01') AND 
        DATE_FORMAT(CURDATE(), '%Y%m%d')
GROUP BY 
    actor_id
ORDER BY 
    total_edits DESC
LIMIT 5;

SQL

Checking query status...