avg weekly edits by edit bucket

SQL

SELECT AVG(group_edits_count), edit_bucket
FROM
(
SELECT 
    COUNT(DISTINCT rev_id) as group_edits_count, 
    WEEKOFYEAR(rev_timestamp) as week_n,
    CASE 
        WHEN user_editcount <= 4 THEN '1 to 4'
        WHEN user_editcount >= 5 AND user_editcount <= 99 THEN '5 to 99'
        WHEN user_editcount >= 100 AND user_editcount <= 999 THEN '100 to 999'
        WHEN user_editcount >= 1000 THEN '1000+'
    END AS edit_bucket
FROM revision
JOIN
(
  SELECT actor_id, user_id, user_name, user_editcount
  FROM actor
  JOIN user
  ON actor.actor_user = user.user_id
  LEFT JOIN user_groups
  ON ug_user = user_id
  WHERE user_editcount>0
  AND (ug_group is null
  OR ug_group NOT IN ('bot', 'flow-bot'))
) total_edits
    ON rev_actor = total_edits.actor_id
WHERE
    rev_timestamp > '{START_DATE}'
    AND rev_timestamp < '{END_DATE}'
GROUP BY WEEKOFYEAR(rev_timestamp), edit_bucket
) AS edits_week_bucket
GROUP BY edits_week_bucket.edit_bucket
SQL

Checking query status...
