Cold Case~55min

The Grant Money That Funded Something Else

GRANT-088's approved categories are reagents, animal_care, and publication_fees — supplies isn't even approved. But 6 expenditures were coded to supplies anyway, with descriptions like "Laptop - Dell XPS 15" and "Monitor 27-inch 4K" — equipment with nothing to do with the grant's research scope. 8 more supplies entries also sound generic, but they're small-dollar consumables like pipette tips and petri dishes, legitimately in scope.

Tables you'll query

grantsgrant_expenditures

What you'll learn

JOINsAggregations & GROUP BYString Functions
Investigate this case →