WITH exp_users AS
  (SELECT uid,
          dt,
          CASE
              WHEN deviceType = 2 THEN 'iOS_Parent'
              WHEN deviceType = 1 THEN 'Android_Parent'
              ELSE 'Unknown'
          END AS platform
   FROM stat.funnelTrack AS ft
   WHERE ft.dt >= '2024-08-15'
     AND action = 'new_haunt_place'
   GROUP BY uid,
            dt,
            3)
SELECT
dt, platform, count(*) as n
FROM exp_users
GROUP BY 1, 2
ORDER BY dt DESC, platform;