SQL Top Five Users by Engagement | Dataford Interview Questions

Write a SQL query to find the top five users by engagement in a given month.

Use February 2025 for the evaluation month. Engagement scores are weighted by event type: views score 1, likes 3, comments 5, and shares 7. Include only events occurring within the month.

Output

Return one row per user with user_id, user_name, engagement_events, and engagement_score.
Return at most five users, ordered by score descending, event 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

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the event
occurred_at	DATE	Date when the engagement occurred
event_type	VARCHAR(20)	Type of engagement activity

Your question is SQL Top Five Users by Engagement. 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