Back to problems

Write SQL for repeat churn

SQL · OpenAI · Hard

Write a single SQL query that reports how a free-month promotion performed relative to a control group. The experiment_users table already contains exactly the users who qualified for the test, so eligibility is decided for you — do not rebuild that filtering inside your query. Lifecycle activity lives in subscription_events. For every user, derive the following from their own event history: The earliest signup row whose event_ts is at or after that user's assigned_at. The…

Checking your access…