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
Investigate this case →