SELECT
action,
CASE
      WHEN (deviceType = 2 AND appVersion % 2 = 0) THEN 'iOS_Parent'
      WHEN (deviceType = 1 AND appVersion % 2 = 1) THEN 'Android_Parent'
      WHEN (deviceType = 2 AND appVersion % 2 = 1) THEN 'iOS_Child'
      WHEN (deviceType = 1 AND appVersion % 2 = 0) THEN 'Android_Child'
      ELSE 'Unknown'
END AS platform,
visitParamExtractString(addJson, 'option') as exp_group,
--dt,
uniqCombined(uid) as users
FROM funnelTrack ft
where dt >= '2024-09-01'
and `action` in ('pteam_notification_setting_in_menu_olduser', 'pteam_notification_setting_in_menu_newuser')
group by 1, 2, 3 --, 4
HAVING users > 100
ORDER BY action, platform, exp_group --, dt;