Advertisement
kirzecy670

Untitled

Feb 4th, 2025
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.44 KB | None | 0 0
  1. SELECT dt,
  2.        ts,
  3.        uid,
  4.        addJson
  5. FROM stat.funnelTrack
  6. WHERE action = 'feature_disabled'
  7.   AND dt >= today() - interval '30' DAY
  8.   AND simpleJSONExtractString(addJson, 'experimentId') = 'android_experiment_pteam_new_magic'
  9. ORDER BY ts DESC
  10. LIMIT 100;
  11.  
  12. SELECT dt,
  13.        count(action) AS n
  14. FROM stat.funnelTrack
  15. WHERE action = 'pteam_new_magic'
  16.   AND dt >= today() - interval '30' DAY
  17. GROUP BY 1
  18. ORDER BY 1 DESC;
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement