Retention of Wikipedia_Asian_Month_2022_Hungary

SQL

WITH reg_users AS 
        (SELECT
            user_registration,
            user_editcount,
            user_name    
        FROM
            user
        WHERE
            user_name IN ('Xia', 'Pallor', 'Molnár Gábor Dávid', 'Zerind', 'Jávori István', 'Csicsikálás', 'Malatinszky', 'Hollófernyiges', 'Seba', 'Blua lago', 'VargaA', 'Holes Ádám', 'Csurla', 'Mugli') AND
            user_registration BETWEEN 20120902091147 AND 20221101091147),
        revision AS (
            SELECT
            COUNT(rev_id),
            actor_name
            FROM
            revision
            JOIN actor ON rev_actor = actor_id
            JOIN reg_users ON reg_users.user_name = actor.actor_name
            WHERE
            rev_timestamp > 20221129203950 AND
            rev_timestamp < 20231124203950
            GROUP BY actor_name
        )
        
        SELECT *
        FROM revision
SQL

Checking query status...
