Sequential Behavior with Window Functions | Dataford Interview Questions

How would you use ROW_NUMBER(), RANK(), LEAD(), and LAG() to analyze sequential user behavior?

Use the users and user_events tables. Exclude events with a NULL event_type and events whose user is not present in users.

Output

One row per included event with user_id, user_name, event_id, event_type, event_time, event_sequence, event_rank, previous_event_type, and next_event_type.
Order by user_id, event_time, and event_id ascending.

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	Display name of the user

user_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(50)	Type of user behavior
event_time	TIMESTAMP	Timestamp when the event occurred

Your question is Sequential Behavior with Window Functions. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.