Completed All Onboarding Steps | Dataford Interview Questions

Write a SQL query to find users who completed all required onboarding steps.

Use the provided users, onboarding_steps, and user_onboarding_steps tables. A step counts as completed only when its completion timestamp is not NULL.

Output

Return one row per qualifying user with user_id, full_name, and email.
Include only users who completed every required step.
Order by user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
full_name	VARCHAR(120)	User's full name
email	VARCHAR(255)	User email address

onboarding_steps

Column	Type	Description
step_idPK	INT	Unique onboarding step identifier
step_name	VARCHAR(100)	Name of the onboarding step
is_required	BOOLEAN	Whether the step is required

user_onboarding_steps

Column	Type	Description
user_id	INT	References users.user_id
step_id	INT	References onboarding_steps.step_id
completed_at	TIMESTAMP	Completion timestamp, or NULL when incomplete

Your question is Completed All Onboarding Steps. Start with the requirements and the three 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