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