Percent more than Average

SQL

#CTE (Common Table Expression) for total edits made by editors across a rolling 3-month period and average edits.
WITH TotalEdits AS (
  		#Calculate total edits per editor over the rolling 3-month period
        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
	),
    AverageEdits As (
      	#Calculate the average total edits across all editors
    	SELECT 
      		AVG(total_edits) AS avg_edits
      	FROM TotalEdits
    )
#Query to get top 5 editors and Compare each top editor's total edits against the overall average
SELECT
	te.editor_id,
    te.editor_name,
    te.total_edits,
	ROUND(((te.total_edits - ae.avg_edits) / ae.avg_edits) * 100, 0) AS percent_more_than_average
FROM TotalEdits te, AverageEdits ae
ORDER BY total_edits DESC 
LIMIT 5
SQL

Checking query status...
