SQL for Engagement Metrics | Dataford Interview Questions

Can you write a SQL query to extract specific user engagement metrics from a database for ABC Education?

Using the users and engagement_events tables, return metrics for every user, including users with no engagement records.

Output

One row per user with user_id, full_name, total_events, active_days, lessons_completed, and last_engagement_at.
Include zero values for users without events and exclude events for unknown users.
Order by total_events descending, then user_id ascending.

users

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(40)	Type of engagement event
engaged_at	TIMESTAMP	Timestamp when the event occurred
lesson_id	INT	Lesson associated with the event, when applicable

Your question is 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.

Can you write a SQL query to extract specific user engagement metrics from a database for ABC Education?

Using the users and engagement_events tables, return metrics for every user, including users with no engagement records.

One row per user with user_id, full_name, total_events, active_days, lessons_completed, and last_engagement_at.
Include zero values for users without events and exclude events for unknown users.
Order by total_events descending, then user_id ascending.

users

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(40)	Type of engagement event
engaged_at	TIMESTAMP	Timestamp when the event occurred
lesson_id	INT	Lesson associated with the event, when applicable

Your question is 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.