SQL for Top Engaged Donors | Dataford Interview Questions

Write a SQL query to find the top 10% of donors who have engaged with our recent email campaigns.

Use campaigns sent on or after 2025-02-01 as recent. A donor is engaged when they have at least one recorded email engagement for a recent campaign.

Output

Return one row per qualifying donor with donor_id, donor_name, total_donated, engaged_campaigns, and donor_rank.
Include only the top 10% of engaged donors, rounding the required count up and breaking ties by donor_id.
Order by donor_rank, then donor_id.

Schema

donors

Column	Type	Description
donor_idPK	INT	Unique donor identifier
donor_name	VARCHAR(100)	Donor display name

email_campaigns

Column	Type	Description
campaign_idPK	INT	Unique email campaign identifier
campaign_name	VARCHAR(150)	Campaign name
sent_at	DATE	Campaign send date

email_engagements

Column	Type	Description
engagement_idPK	INT	Unique engagement identifier
donor_id	INT	Referenced donor
campaign_id	INT	Referenced email campaign
event_type	VARCHAR(30)	Engagement event such as open or click

donations

Column	Type	Description
donation_idPK	INT	Unique donation identifier
donor_id	INT	Referenced donor
amount	NUMERIC(12,2)	Donation amount

Your question is SQL for Top Engaged Donors. Start with the requirements and the four 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.

Problem