Product Adoption Within Fourteen Days

For each signup, find the first feature_activated event occurring from signup_at through exactly 14 days later. Events before signup and other event types do not qualify. Duplicate adoption events must produce one result. Return account_id, signup_at, first_adoption_at and days_to_adoption for adopted accounts only. Return columns: account_id, signup_at, first_adoption_at, days_to_adoption.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

For each signup, find the first feature_activated event occurring from signup_at through exactly 14 days later. Events before signup and other event types do not qualify. Duplicate adoption events must produce one result. Return account_id, signup_at, first_adoption_at and days_to_adoption for adopted accounts only. Return columns: account_id, signup_at, first_adoption_at, days_to_adoption.

Difficulty: Advanced
SQL concept: CTE