Untitled

kirzecy670

Jun 13th, 2025

306

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 0.82 KB | None | 0 0

raw download clone embed print report

WITH
open_first AS (
SELECT uid
FROM stat.funnelTrack
WHERE ts >= '2025-06-13 00:00:00'
AND action = 'open_first'
),
ax AS (
SELECT
uid,
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
FROM stat.funnelTrack
WHERE dt >= today()
AND action IN ('ios_gmd_57484_newApp_v01_ru_experiment', 'android_gmd_57483_newApp_v01_ru_experiment')
AND region = 'ru'
AND simpleJSONExtractString(addJson, 'option') = 'new'
)
SELECT * FROM ax
ORDER BY rand();

Add Comment

Please, Sign In to add comment