lettings · v1 · Head of Lettings
7,690
homes at Mon 20:00
A lease started before now and the tenant not moved out before now.
lettings · changed 2026-11-01: First version.
Tests
- count_between min 6500.0 max 8000.0
- unique on unit_id
SQL
SELECT DISTINCT l.unit_id, l.building_id
FROM leases l
WHERE l.start_date <= {now} AND (l.moved_out_at IS NULL OR l.moved_out_at > {now})
ORDER BY l.unit_id