By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | house | room1 | room2 | room3 |
|---|---|---|---|---|
| 1 | a | empty | empty | occupied |
| 2 | b | empty | full | empty |
| 3 | c | occupied | occupied | empty |
| id | house | room1 | room2 | room3 |
|---|---|---|---|---|
| 1 | a | empty | empty | occupied |
| 2 | b | empty | full | empty |
| 3 | c | occupied | occupied | empty |