First Feature Interaction After Signup | Dataford Interview Questions

Your question is First Feature Interaction After Signup. Start with the requirements and the two tables on the right.

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

Problem

NovaApp wants to understand which product feature each user touches first after creating an account. Write a SQL query to return the first feature interaction that happened on or after each user's signup timestamp.

Requirements

Return one row per user who has at least one valid interaction after signup.
Include user_id, email, signup_at, feature_name, and first_interaction_at.
Ignore events that occurred before signup.
If a user has multiple valid events at the exact same timestamp, return the one with the smaller event_id.
Order the final result by user_id.

Schema

users

Column	Type	Description
user_idPK	INT	Unique identifier for a user
email	VARCHAR(255)	User email address
signup_at	TIMESTAMP	Timestamp when the user signed up
plan_tier	VARCHAR(50)	Subscription plan tier

feature_events

Column	Type	Description
event_idPK	INT	Unique identifier for an event
user_id	INT	User who generated the event
feature_name	VARCHAR(100)	Name of the feature the user interacted with
event_at	TIMESTAMP	Timestamp of the feature interaction
device_type	VARCHAR(50)	Device type used for the interaction