Top Engaged Users SQL | Dataford Interview Questions

Write a SQL query to find the top 10 most engaged users in the last month.

For this exercise, engagement is defined as the number of user event records during the previous calendar month. Include users with no qualifying events, treating their engagement count as zero.

Output

One row per user, with user_id, user_name, and engagement_count.
Include up to 10 users, ordered by engagement count descending and user_id ascending to break ties.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	Display name of the user

user_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(30)	Type of user engagement event
occurred_at	TIMESTAMP	Timestamp when the event occurred

Your question is Top Engaged Users SQL. 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