By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| datetime | poo | pee |
|---|---|---|
| 2020-10-12 08:15:00 | 1 | 1 |
| 2020-10-12 10:00:00 | 0 | 1 |
| 2020-10-12 12:25:00 | 0 | 1 |
| 2020-10-12 12:55:00 | 1 | 1 |
| 2020-10-12 15:35:00 | 0 | 1 |
| 2020-10-12 16:30:00 | 0 | 1 |
| 2020-10-12 18:10:00 | 0 | 1 |
| 2020-10-12 18:47:00 | 0 | 1 |
| 2020-10-12 20:25:00 | 1 | 1 |
| datetime | poo | pee | poo_diff | pee_diff |
|---|---|---|---|---|
| 2020-10-12 08:15:00 | 1 | 1 | null | null |
| 2020-10-12 10:00:00 | 0 | 1 | null | 01:45:00 |
| 2020-10-12 12:25:00 | 0 | 1 | null | 02:25:00 |
| 2020-10-12 12:55:00 | 1 | 1 | 04:40:00 | 00:30:00 |
| 2020-10-12 15:35:00 | 0 | 1 | null | 02:40:00 |
| 2020-10-12 16:30:00 | 0 | 1 | null | 00:55:00 |
| 2020-10-12 18:10:00 | 0 | 1 | null | 01:40:00 |
| 2020-10-12 18:47:00 | 0 | 1 | null | 00:37:00 |
| 2020-10-12 20:25:00 | 1 | 1 | 07:30:00 | 01:38:00 |