WITH filtered_data AS (
    SELECT DISTINCT uid
    FROM stat.funnelTrack
    WHERE action IN ('feature_disabled', 'feature_deactivated')
      AND dt >= '2025-06-01'
      AND (
          simpleJSONExtractString(addJson, 'experiment') = 'android_gmd_57483_newApp_v01_ru_experiment'
          OR simpleJSONExtractString(addJson, 'experimentId') = 'android_gmd_57483_newApp_v01_ru_experiment'
      )
      AND simpleJSONExtractString(addJson, 'details') = 'first install does not match'
)

SELECT
    dt,
    count(uid) AS events_count,
    uniqCombined(uid) AS unique_users
FROM stat.funnelTrack
WHERE dt >= '2025-06-01'
  AND action = 'open_first'
  AND uid IN (SELECT uid FROM filtered_data)
GROUP BY dt
ORDER BY dt DESC