Tricky~21min
The Vacant Unit Still Billing Rent
6 units moved out with no new lease signed, but rent invoices kept generating for 3 more months afterward — nobody told billing the unit was empty. 8 other vacated units also got an invoice after move-out, but it was a one-off vacancy_utility charge the owner legitimately covers on an empty unit, not rent.
Tables you'll query
leasesinvoices
What you'll learn
JOINsDate & Time Functions