how many times "user A" trigger "event X" before triggering "event Y"
SELECT COUNT(*)
FROM events
WHERE userName = 'user A'
AND eventType = 'event X'
AND date < (SELECT date FROM events WHERE userName = 'user A' AND eventType = 'event Y');
- Public
- ·
- Fri, 24 Feb 2023 17:42:20 GMT