WITH ax AS (
    SELECT
        ft.uid AS uid,
        MAX(visitParamExtractString(ft.addJson, 'option')) AS exp_group,
        MIN(dt) AS dt
    FROM
        stat.funnelTrack AS ft
    WHERE
        ft.dt >= '2024-12-03'
        AND ft.action = 'pteam_appstat_v31'
    GROUP BY
        ft.uid
    HAVING
        exp_group IN ('old', 'new'))
SELECT dt, exp_group, count(*) AS n FROM ax GROUP BY 1, 2 ORDER BY 1 DESC, 2;