By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | attendee_name | event_logs |
|---|---|---|
| 1 | p1 | {"checkIn":{"check_in_0":" 31.07.2021 02:00:00 am","check_in_1":" 31.07.2021 10:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 04:00:00 am","check_out_1":" 31.07.2021 11:00:00 am"}} |
| 2 | p2 | {"checkIn":{"check_in_0":" 31.07.2021 03:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 04:00:00 am"}} |
| 3 | p3 | {"checkIn":{"check_in_0":" 31.07.2021 9:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 9:30:00 am"}} |
| id | attendee_name | event_logs | level | check_in | check_out |
|---|---|---|---|---|---|
| 1 | p1 | {"checkIn":{"check_in_0":" 31.07.2021 02:00:00 am","check_in_1":" 31.07.2021 10:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 04:00:00 am","check_out_1":" 31.07.2021 11:00:00 am"}} | 0 | " 31.07.2021 02:00:00 am" | " 31.07.2021 04:00:00 am" |
| 2 | p2 | {"checkIn":{"check_in_0":" 31.07.2021 03:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 04:00:00 am"}} | 0 | " 31.07.2021 03:00:00 am" | " 31.07.2021 04:00:00 am" |
| 3 | p3 | {"checkIn":{"check_in_0":" 31.07.2021 9:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 9:30:00 am"}} | 0 | " 31.07.2021 9:00:00 am" | " 31.07.2021 9:30:00 am" |
| 1 | p1 | {"checkIn":{"check_in_0":" 31.07.2021 02:00:00 am","check_in_1":" 31.07.2021 10:00:00 am"},"checkOut":{"check_out_0":" 31.07.2021 04:00:00 am","check_out_1":" 31.07.2021 11:00:00 am"}} | 1 | " 31.07.2021 10:00:00 am" | " 31.07.2021 11:00:00 am" |