Top Three Active Users | Dataford Interview Questions

Write a query utilizing window functions such as ROW_NUMBER or DENSE_RANK to identify the top three active users per region over the last quarter.

Treat users with is_active = true as active. Count each user's activity during the previous calendar quarter based on activity_at.

Output

Return one row per qualifying user with region, user_id, user_name, activity_count, and activity_rank.
Include users whose activity count places them within the top three ranks in their region, including ties.
Order by region, activity_rank, and user_id.

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
region	VARCHAR(50)	User's geographic region
is_active	BOOLEAN	Whether the user is currently active

user_activity

Column	Type	Description
activity_idPK	INT	Unique activity identifier
user_id	INT	User associated with the activity
activity_at	TIMESTAMP	Timestamp when the activity occurred
activity_type	VARCHAR(50)	Type of user activity

Your question is Top Three Active Users. 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.