Top Engaged Users by Region

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Top Engaged Users by Region. Start with the requirements and the two 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.

You need to log in / sign up to run or submit.

Problem

Asana Spa wants to identify its most engaged users across regional teams. Write a PostgreSQL query that finds the top three users in each region based on activity during the last 30 days.

Assume CURRENT_DATE is 2026-08-29 when validating the sample data.

Requirements

Join users to their activity events and restrict events to the last 30 days.
Count activity events for each user.
Rank users independently within each region, showing at most three users per region.
Return ties deterministically by sorting activity count descending and user ID ascending.

Schema

users

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

activity_events

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

Tablesusersactivity_events

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results