SQL Top Users by Region | Dataford Interview Questions

Your question is SQL Top Users by Region. Start with the requirements and the three tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Acumen wants to identify its most engaged users in each region. Write a PostgreSQL query that calculates engagement scores from recent Acumen activity and returns the top three ranks per region, preserving ties.

Use 2026-08-29 12:00:00+00 as the report timestamp so the result is reproducible. The reporting window includes events from the preceding 30 days, including the timestamp boundary.

Requirements

Join users to engagement events and event types to calculate each user's score.
Assign points from event_types.points and treat users with no scored activity as having a score of zero.
Rank users independently within each region using a tie-aware window function.
Return every user whose rank is at most 3, including all users tied at the third rank.
Order results by region, rank, and user ID.

Representative data

Schema

users

Column	Type	Description
user_idPK	INT	Unique Acumen user identifier
user_name	VARCHAR(100)	User display name
region	VARCHAR(50)	User's geographic region

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User who generated the event
event_type_id	INT	Type of engagement event
occurred_at	TIMESTAMPTZ	Timestamp when the event occurred

event_types

Column	Type	Description
event_type_idPK	INT	Unique event type identifier
event_name	VARCHAR(50)	Human-readable event name
points	INT	Engagement points awarded for the event