By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
| hotel_id | roomtype_id | status | booking_timestamp | checkin_date | checkout_date |
|---|---|---|---|---|---|
| 1 | 1 | new | 2023-02-02 00:15:30 | 2023-02-03 | 2023-02-05 |
| 1 | 1 | new | 2023-02-04 09:10:15 | 2023-02-04 | 2023-02-04 |
| 1 | 1 | new | 2023-02-07 03:00:10 | 2023-02-09 | 2023-02-10 |
| 1 | 1 | new | 2023-02-08 04:10:10 | 2023-02-09 | 2023-02-10 |
| 1 | 1 | cancelled | 2023-02-08 10:15:30 | 2023-02-09 | 2023-02-10 |
| 2 | 2 | new | 2023-02-03 06:40:14 | 2023-02-06 | 2023-02-07 |
| 2 | 2 | new | 2023-02-05 08:10:14 | 2023-02-06 | 2023-02-08 |
| hotel_id | roomtype_id | the_date | amount |
|---|---|---|---|
| 1 | 1 | 2023-02-01 | 0 |
| 1 | 1 | 2023-02-02 | 0 |
| 1 | 1 | 2023-02-03 | 1 |
| 1 | 1 | 2023-02-04 | 2 |
| 1 | 1 | 2023-02-05 | 1 |
| 1 | 1 | 2023-02-06 | 0 |
| 1 | 1 | 2023-02-07 | 0 |
| 1 | 1 | 2023-02-08 | 0 |
| 1 | 1 | 2023-02-09 | 1 |
| 1 | 1 | 2023-02-10 | 1 |
| 2 | 2 | 2023-02-01 | 0 |
| 2 | 2 | 2023-02-02 | 0 |
| 2 | 2 | 2023-02-03 | 0 |
| 2 | 2 | 2023-02-04 | 0 |
| 2 | 2 | 2023-02-05 | 0 |
| 2 | 2 | 2023-02-06 | 2 |
| 2 | 2 | 2023-02-07 | 2 |
| 2 | 2 | 2023-02-08 | 1 |
| 2 | 2 | 2023-02-09 | 0 |
| 2 | 2 | 2023-02-10 | 0 |