By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| house | rent_start | rent_end | duration |
|---|---|---|---|
| A | 2019-01-01 | 2019-12-31 | 12 |
| C | 2019-04-01 | 2019-12-31 | 8 |
| house | rent_start | rent_end | duration |
|---|---|---|---|
| A | 2019-01-01 | 2019-12-31 | 12 |
| C | 2019-04-01 | 2019-12-31 | 8 |