Cold Case~60min

The Damage Deductions With No Repair Behind Them

Property manager Rosa Kim (MGR-04) withheld "damage_repair" deductions from 6 tenant deposits across her 5 properties, totaling $4,095.00 — but not one of those deductions has a matching vendor invoice on file. No repair vendor was ever paid. MGR-03 also withheld a large $1,100.00 damage_repair deduction on one lease, but it has a matching invoice from ProFix Contractors for the exact same amount — a legitimate repair, not skimming.

Tables you'll query

propertiesleasesvendor_invoicesdeposit_deductions

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →