Output: First-Touch Attribution Result

What campaign_id is returned for user 10? SELECT user_id, campaign_id FROM (SELECT user_id, campaign_id, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY touch_time) rn FROM campaign_touches) t WHERE rn = 1 AND user_id = 10;