Non-bot revisions and typed commend length average per day

SQL

#SELECT AVG(avg_num_revisions) AS avg_num_revisions_per_day
#AVG(avg_comment_length) AS avg_comment_length_per_day
#FROM (
  SELECT 
  day_portion,
  COUNT(rc_timestamp) AS avg_num_revisions,
  AVG(true_comment_length) AS avg_comment_length
  FROM (
  SELECT
	day_portion,
    COUNT(rc_timestamp) AS avg_num_revisions,
    AVG(true_comment_length) AS avg_comment_length
FROM (
        SELECT
  		SUBSTRING(rc.rc_timestamp, 7, 2) AS day_portion,
        cr.comment_text,
        LENGTH(
            -- Remove /* */ comments from the comment_text
            REGEXP_REPLACE(cr.comment_text, '/\\*.*?\\*/', '') 
        ) AS true_comment_length
    FROM
        recentchanges rc
    JOIN
        comment_recentchanges cr ON rc.rc_comment_id = cr.comment_id
    WHERE
        rc.rc_bot <> 1 AND
        rc.rc_source = "mw.edit" AND
        NOT cr.comment_text LIKE 'Undid revision%' AND
        NOT cr.comment_text LIKE 'Restored revision%'
)
  WHERE NOT day_portion LIKE DAY(CURRENT_TIMESTAMP)

) #AS latest_non_bot_revisions 
   # Group by day_portion
#)
SQL

Checking query status...
