By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| Name | RoomType | Los | MealPlan | Price | StartDate | EndDate | CaptureDate |
|---|---|---|---|---|---|---|---|
| A | DLX | 7 | RO | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| A | DLX | 7 | BB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| A | DLX | 7 | HB | 154 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| A | DLX | 7 | FB | 200 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| B | SUP | 7 | RO | 110 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| B | SUP | 7 | BB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| B | SUP | 7 | HB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| B | SUP | 7 | FB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| C | COS | 7 | RO | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| C | COS | 7 | BB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| C | COS | 7 | HB | 200 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| C | COS | 7 | FB | 139 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| D | STD | 7 | RO | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| D | STD | 7 | BB | 75 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| D | STD | 7 | HB | 0 | 2022-01-01 | 2022-01-07 | 2021-12-31 |
| D | STD | 7 | FB | 500 | 2022-01-01 | 2022-01-07 | 2021-12-31 |