← Problems8. Sessionize clickstream eventsHardSQL
00:00 / 20:00

Sessionize clickstream events

Hard·Acceptance ·Asked at Swiggy

Group events into sessions with a 30-minute inactivity gap and return session_id, user_id, start, end.

Topics

window functions

Similar problems

Community-reported interview topic. Not an official company question and no affiliation is implied.

solution.sql
Loading editor…
Draft not saved yet · Spaces 4 · UTF-8 · ⌘↵ run, ⌘⇧↵ submit
Nothing run yet

Run against the public tests, or submit to score against all of them.