SQL pattern · P24 · 8 problems

Sessionization and event sequences

Graded problems on sessionization and event sequences, from easy to hard.

8 problems · about 1 h 20 min in all

Start with problem 01Minutes since previous event per user · 5 min

Learn it first · P24The session that joins two usersA LAG without PARTITION BY measures the gap across users and merges their journeys.Read the lesson →

Easy

2 problems · about 10 min

01Minutes since previous event per user5 min →02Flag each event as starting a new session5 min →

Medium

4 problems · about 31 min

03Number each user's sessions8 min →04Session duration in seconds7 min →05Entry and exit page per session8 min →06Logout event also starts a new session8 min →

Hard

2 problems · about 40 min

07Per session: did it convert? And how long until purchase?15 min →08Capped sessions from a late, duplicated event stream25 min →