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