By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
start_time | end_time | booking |
---|---|---|
2020-09-01 10:00:00 | 2020-09-01 10:10:00 | Booking 1 |
2020-09-01 10:00:00 | 2020-09-01 10:05:00 | Booking 2 |
2020-09-01 10:05:00 | 2020-09-01 10:10:00 | Booking 3 |
2020-09-01 10:09:00 | 2020-09-01 10:10:00 | Booking 4 |
start_time | count(*) |
---|---|
2020-09-01 10:00:00 | 2 |
2020-09-01 10:01:00 | 2 |
2020-09-01 10:02:00 | 2 |
2020-09-01 10:03:00 | 2 |
2020-09-01 10:04:00 | 2 |
2020-09-01 10:05:00 | 3 |
2020-09-01 10:06:00 | 2 |
2020-09-01 10:07:00 | 2 |
2020-09-01 10:08:00 | 2 |
2020-09-01 10:09:00 | 3 |
2020-09-01 10:10:00 | 3 |