SQL: Top Engaged Save Interactors | Dataford Interview Questions

Your question is SQL: Top Engaged Save Interactors. 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

Meta's Product Growth team is evaluating Instagram Save engagement across regions. Using quarterly interaction and engagement data, write a PostgreSQL query to find the top three users in each region who interacted with an Instagram Save feature during Q2 2025.

Requirements

Filter instagram_save_interactions to completed Instagram Save interactions from 2025-04-01 through 2025-06-30, inclusive.
Aggregate each qualifying user's engagement score and engagement event count during the same quarter. Users with no engagement events must remain eligible with a score of zero.
Rank users independently within each non-null region by engagement score descending, breaking ties with user_id ascending, and return ranks 1 through 3.

Schema

users

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

instagram_save_interactions

Column	Type	Description
interaction_idPK	INT	Unique Save interaction identifier
user_id	INT	User who performed the interaction
feature_name	VARCHAR(100)	Instagram feature involved in the interaction
interacted_at	DATE	Date of the interaction

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the event
event_date	DATE	Date of the engagement event
engagement_score	INT	Weighted engagement score for the event