Percent more than Average

SQL

#CTE (Common Table Expression) for total edits made by editors across a rolling 3-month period.
WITH TotalEdits AS (
	SELECT 
        actor_id AS editor_id,
        actor_name AS editor_name,
        COUNT(DISTINCT rev_id) AS total_edits
    FROM revision
    JOIN actor ON rev_actor = actor_id
    WHERE rev_timestamp >= DATE_FORMAT(DATE_SUB(CURRENT_DATE(), INTERVAL 2 MONTH), '%Y%m%01000000')
    GROUP BY actor_id,actor_name
)

SELECT
	editor_id,
    editor_name,
    total_edits,
	((total_edits - AVG(total_edits))/ AVG(total_edits))*100 AS percent_more_than_average
FROM TotalEdits
ORDER BY total_edits DESC 
LIMIT 5
SQL

Checking query status...
