By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 8
| dt_start | dt_end | agent_id |
|---|---|---|
| 2024-01-01 08:00:00 | 2024-01-01 08:10:00 | 3148 |
| 2024-01-01 08:20:00 | 2024-01-01 08:30:00 | 3148 |
| 2024-01-01 08:31:00 | 2024-01-01 08:33:00 | 3148 |
| 2024-01-01 08:35:00 | 2024-01-01 08:38:00 | 3148 |
| 2024-01-01 08:40:00 | 2024-01-01 08:41:00 | 3148 |
| 2024-01-01 08:44:00 | null | 3148 |
| 2024-01-01 08:25:00 | 2024-01-01 08:35:00 | 31 |
| 2024-01-01 08:40:00 | 2024-01-01 08:45:00 | 31 |
SELECT 8
CREATE TABLE
INSERT 0 8
| dt | agent_id | status |
|---|---|---|
| 2024-01-01 08:00:00 | 3148 | 1 |
| 2024-01-01 08:15:10 | 3148 | 2 |
| 2024-01-01 08:22:30 | 3148 | 3 |
| 2024-01-01 08:34:00 | 3148 | 1 |
| 2024-01-01 08:41:00 | 3148 | 2 |
| 2024-01-01 08:45:00 | 3148 | 3 |
| 2024-01-01 08:20:00 | 31 | 1 |
| 2024-01-01 08:35:00 | 31 | 2 |
SELECT 8