Funnel Conversion Rate SQL | Dataford Interview Questions

Write a SQL query to calculate the conversion rate between two stages of the funnel.

Assume the stages are signup and assessment_started. Include only non-test users, count each user once, and consider a conversion valid only when the second stage occurs after the first.

Output

One row containing from_stage, to_stage, from_users, converted_users, and conversion_rate_pct
Return the conversion rate as a percentage rounded to two decimal places

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
is_test	BOOLEAN	Whether the account is a test user

funnel_events

Column	Type	Description
event_idPK	INT	Unique funnel event identifier
user_id	INT	User associated with the event
stage	VARCHAR(50)	Funnel stage recorded by the event
event_time	TIMESTAMP	Time when the funnel event occurred

Your question is Funnel Conversion Rate SQL. 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