SQL Top Three Users Per Region | Dataford Interview Questions

Use common table expressions and window functions to identify the top three most active users in each region on LinkedIn.

Count every activity event associated with a user. Users without activity should not appear, and ties should be resolved by the smaller user ID.

Output

One row per selected user, with region, user_id, full_name, activity_count, and activity_rank.
Include no more than three users per region.
Order by region, activity_rank, then user_id.

users

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

activity_events

Column	Type	Description
activity_idPK	INT	Unique activity event identifier
user_id	INT	User associated with the activity event
event_type	VARCHAR(50)	Type of LinkedIn activity

Your question is SQL Top Three Users Per Region. 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.