User Session: Track and Analyze User Session Activity With Duration and Event Counts

Problem You have a table of user events with timestamps. A session is a sequence of events from the same user with no gap exceeding 30 minutes. Compute per-user: number of sessions, average session duration in minutes, and the session with the most events. Expected output: Approach Use window functions: LAG(created_at) OVER (PARTITION BY user_id ORDER BY created_at) to compute gaps, then mark session boundaries, assign session IDs with a running sum, and aggregate. Follow-ups Write the full SQL…