SQL: Top Engaged Save Interactors

MediumSQL · PostgreSQL

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

Tablesusersinstagram_save_interactionsengagement_events