Cold Case~55min

The Matching Gift That Was Claimed Twice

6 employer_gift_ids show up in match_requests submitted by two different nonprofits, for the exact same amount and date — the same corporate-match dollar drawn down twice for one gift. 9 more cases show the same donor submitting to two different nonprofits close in time, but those are genuinely separate donations, each with a distinct employer_gift_id and a different amount.

Tables you'll query

donationsmatch_requests

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →