Sample SQL for Engagement Metrics | Dataford Interview Questions

Write a sample query to retrieve user engagement metrics from a dataset.

Use the users and engagement_events tables. Include users with no engagement records, ignore events without a user ID, and treat NULL event dates as unavailable.

Output

One row per user with user_id, user_name, engagement_event_count, active_days, and last_engagement_date
Include all users, including those with zero events; rows with a NULL event date contribute no active day and have a NULL last date
Order by user_id ascending

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique user identifier
user_name	VARCHAR(100)	Display name of the user
country	VARCHAR(2)	Two-letter country code

engagement_events

Column	Type	Description
event_idPK	INTEGER	Unique engagement event identifier
user_id	INTEGER	User associated with the event
event_type	VARCHAR(20)	Type of engagement event
event_date	DATE	Calendar date of the event

Your question is Sample SQL for Engagement Metrics. 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