Untitled query #87178

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 3 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 ,((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 3 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...
