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…