Top 10 Engaged Users SQL | Dataford Interview Questions

Write a SQL query to find the top 10 most engaged users in the past month for SmartNews.

Treat a user's engagement as the sum of engagement_points from their qualifying events during the past month, excluding users whose total is zero or unavailable.

Output

One row per qualifying user with user_id, display_name, total_engagement, and event_count.
Return at most 10 users, ordered by total engagement descending, event count descending, and user ID ascending to break remaining ties.

Schema

users

Column	Type	Description
user_idPK	INT	Unique SmartNews user identifier
display_name	VARCHAR(100)	User display name

engagement_events

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

Your question is Top 10 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