DataLemur: Second Day Confirmation

1
2
3
4
5
6

SELECT user_id
FROM emails JOIN texts ON emails.email_id = texts.email_id
WHERE (
  signup_action = 'Confirmed' AND
  (EXTRACT(DAY FROM action_date) - EXTRACT(DAY FROM signup_date)) = 1
)