Tricky~24min

The Restricted Donation Spent on the Wrong Program

10 donations restricted to a specific program had their funds allocated to a genuinely different program — a real violation of donor intent. 12 more restricted donations look mismatched on a strict string comparison, but the allocated program is the exact same one, just cased and padded differently.

Tables you'll query

donationsfund_allocations

What you'll learn

JOINsString Functions
Investigate this case →