Feature Usage After Onboarding | Dataford Interview Questions

Write a SQL query to calculate the percentage of users who used a feature after onboarding.

Use the users and feature_events tables. Count only users with a non-null onboarding timestamp, and treat an event as post-onboarding only when its timestamp is later than onboarding.

Output

Return one row with percentage_users, users_who_used_after, and onboarded_users.
Round the percentage to two decimal places.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
onboarding_at	TIMESTAMP	Timestamp when the user completed onboarding

feature_events

Column	Type	Description
event_idPK	INT	Unique feature event identifier
user_id	INT	User who generated the feature event
used_at	TIMESTAMP	Timestamp when the feature was used

Your question is Feature Usage After Onboarding. 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