SQL Practice Logo

SQLPractice Online

Level 3 - IntermediateScenario-Based Questions

Scenario: First-Touch Campaign Attribution

Return each user's first campaign touch before first purchase. Show user_id and campaign_id.

Schema Context

campaign_touches(id, user_id, campaign_id, touch_time), purchases(id, user_id, purchase_time)