Find Drop-Off After Step | Dataford Interview Questions

Write a SQL query to identify users who dropped off after a specific step in a process.

For this exercise, the specific step is identity_verification, and the next step is card_selection. Identify users who completed the specific step but have no completed event for the next step.

Output

One row per dropped-off user
Columns: user_id, target_completed_at, and next_step
Sort by user_id in ascending order

Schema

process_steps

Column	Type	Description
step_idPK	INT	Unique process step identifier
process_name	VARCHAR(100)	Name of the process
step_name	VARCHAR(100)	Name of the process step
step_order	INT	Position of the step in the process

process_events

Column	Type	Description
event_idPK	INT	Unique process event identifier
user_id	INT	User associated with the event
step_id	INT	Referenced process step
event_status	VARCHAR(30)	Status recorded for the event
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is Find Drop-Off After Step. 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.

Problem