Sign-up confirmed the next day
TikTok is analyzing new-user behavior. Find users who confirmed their email by SMS exactly one day after signing up, not on the sign-up day itself. The condition is action_date − signup_date = 1. Return user_id.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| user_id |
|---|
| 1 |
| 4 |
| 8 |
TikTok
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid