By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | time | log_type |
|---|---|---|
| 1111 | 2021-06-01 07:13:42.000000 | IN |
| 1111 | 2021-06-01 17:13:42.000000 | OUT |
| 1111 | 2021-06-03 07:00:42.000000 | IN |
| 1111 | 2021-06-03 17:00:42.000000 | OUT |
| 2222 | 2021-06-01 07:13:42.000000 | IN |
| 2222 | 2021-06-01 17:13:42.000000 | OUT |
| 2222 | 2021-06-03 07:00:42.000000 | IN |
| 2222 | 2021-06-03 17:00:42.000000 | OUT |
| id | date | IN | OUT |
|---|---|---|---|
| 1111 | 2021-06-01 | 07:13:42.000000 | 17:13:42.000000 |
| 1111 | 2021-06-02 | N/A | N/A |
| 1111 | 2021-06-03 | 07:00:42.000000 | 17:00:42.000000 |
| 2222 | 2021-06-01 | 07:13:42.000000 | 17:13:42.000000 |
| 2222 | 2021-06-02 | N/A | N/A |
| 2222 | 2021-06-03 | 07:00:42.000000 | 17:00:42.000000 |