WITH exp_users AS
  (SELECT ft.uid AS UID,
          MAX(visitParamExtractString(ft.addJson, 'option')) AS exp_group
   FROM stat.funnelTrack AS ft
   WHERE ft.dt >= '2024-12-01'
     AND ft.action = 'pteam_appstat_v31'
   GROUP BY ft.uid
   HAVING exp_group IN ('old',
                        'new'))
SELECT dt,
       exp_users.uid != '' AS flg_,
       uniqCombined(UID) AS users,
       round(users/sum(users) OVER (PARTITION BY dt), 3) AS SHARE
FROM stat.funnelTrack ft
LEFT JOIN exp_users USING (UID)
WHERE dt >= '2024-12-01'
  AND `action` = 'pteam_route_redesign'
  AND appVersion >= '2008321'
GROUP BY 1,
         2
ORDER BY 1,
         2 DESC;