Non-bot revisions and typed commend length average per day

SQL

SELECT
    DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(rc_timestamp), 'UTC', 'CST'), '%Y-%m-%d') AS revision_date,
    COUNT(rc_bot) AS num_revisions
FROM (
    SELECT
        rc.rc_bot,
        cr.comment_text,
        LENGTH(
            -- Remove /* */ comments from the comment_text
            REGEXP_REPLACE(cr.comment_text, '/\\*.*?\\*/', '') 
        ) AS true_comment_length,
        rc.rc_timestamp
    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%'
        -- Add additional conditions to filter by the past 10 days
        AND rc.rc_timestamp >= UNIX_TIMESTAMP(DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY))
) AS latest_non_bot_revisions
GROUP BY
    revision_date
ORDER BY
    revision_date;
SQL

Checking query status...
