SQL Practice Logo

SQLPractice Online

Level 4 - Mid-LevelOutput Prediction Questions

Output: First Event per User

What event_name is returned for user_id = U2? SELECT user_id, event_name FROM (SELECT user_id, event_name, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY event_time) AS rn FROM events) t WHERE rn = 1;