Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH ax AS (
- SELECT
- uid,
- dt,
- count(uid) as n_events
- FROM stat.funnelTrack
- WHERE dt >= '2025-06-05'
- AND appVersion >= 69550
- AND deviceType = 2
- AND appVersion % 2 = 0
- AND action IN ('full_register')
- GROUP BY 1, 2
- )
- SELECT uid, dt, n_events
- FROM ax
- WHERE n_events >= 2
- ORDER BY n_events DESC
- LIMIT 10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
