SQL Top User Segments | Dataford Interview Questions

Write a SQL query to identify the top three user segments by engagement over the last quarter.

Use the provided Wise. Energy user, segment, and engagement data. Define engagement as the number of engagement events during the previous calendar quarter.

Output

One row per selected segment with segment_name, engagement_count, and active_users
Include only the top three segments, ordered by engagement count descending and segment ID ascending for ties

Output details

Treat DATE '2026-09-15' as today's date.
Count active_users as distinct users having at least one engagement event during the previous calendar quarter.
Exclude segments with no engagement events during the previous calendar quarter.
Order final ties by segment_name ascending, despite selecting tied ranks by segment ID ascending.

Schema

segments

Column	Type	Description
segment_idPK	INT	Unique user segment identifier
segment_name	VARCHAR(100)	Display name of the user segment

users

Column	Type	Description
user_idPK	INT	Unique Wise. Energy user identifier
segment_id	INT	Assigned user segment

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the engagement event
event_type	VARCHAR(50)	Type of engagement activity
event_timestamp	TIMESTAMP	Timestamp when the engagement occurred

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the three tables are in the Question tab.

Problem