WITH
    experiment_users AS (
        SELECT
            uid,
            MIN(dt) AS last_activity_date,
            MIN(visitParamExtractString(addJson, 'option')) AS experiment_group
        FROM
            stat.funnelTrack
        WHERE
            dt >= '2025-02-01'
            AND dt < '2025-03-01'
            AND action = 'pteam_new_magic'
        GROUP BY
            uid
    ),
    activity_users AS (
        SELECT
            uid,
            dt
        FROM
            stat.funnelTrack
        WHERE
            dt >= '2025-02-01'
            AND dt < '2025-03-01'
            AND action IN ('full_register', 'open_parent_activity')
        GROUP BY
            uid, dt
        HAVING COUNT(DISTINCT action) = 2
    ),
    localized_users AS (
        SELECT
            uid
        FROM
            analytics.parent_properties
        WHERE
            device_language IN ('en', 'ru')
    )
SELECT
    a.dt AS date,
    COUNT(a.uid) AS total_users,
    COUNT(a.uid) FILTER (WHERE lu.uid != '') AS users_en_ru_locale,
    COUNT(a.uid) FILTER (WHERE eu.uid != '') AS users_in_experiment
FROM
    activity_users a
LEFT JOIN
    localized_users lu ON a.uid = lu.uid
LEFT JOIN
    experiment_users eu ON a.uid = eu.uid
GROUP BY
    a.dt
ORDER BY
    a.dt;