By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
21 rows affected
RoomCode | Occupancy | Time | DayFromDate |
---|---|---|---|
EW1A-03-08 | 0 | 07/10/2019 08:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 08:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 08:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 09:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 09:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 09:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 10:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 10:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 10:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 11:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 11:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 12:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 12:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 13:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 13:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 14:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 14:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 15:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 15:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 15:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 16:00:00 | Wednesday |
4 rows affected
RoomCode | Occupancy | Time | DayFromDate |
---|---|---|---|
EW1A-03-08 | 0 | 07/10/2019 08:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 08:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 09:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 09:30:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 10:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 10:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 11:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 11:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 12:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 12:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 13:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 13:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 14:00:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 14:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 15:00:00 | Wednesday |
EW1A-03-08 | 1 | 07/10/2019 15:30:00 | Wednesday |
EW1A-03-08 | 0 | 07/10/2019 16:00:00 | Wednesday |