By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
| start_tz | end_tz | sensor_id | status |
|---|---|---|---|
| 2022-01-01 00:00:00+00 | 2022-01-01 00:20:00+00 | 1 | stationary |
| 2022-01-01 00:00:00+00 | 2022-01-01 00:20:00+00 | 2 | in_motion |
| 2022-01-01 00:00:00+00 | 2022-01-01 00:20:00+00 | 3 | in_motion |
| 2022-01-01 00:00:00+00 | 2022-01-01 00:20:00+00 | 4 | stationary |
| 2022-01-01 00:20:00+00 | 2022-01-01 00:40:00+00 | 1 | in_motion |
| 2022-01-01 00:20:00+00 | 2022-01-01 00:40:00+00 | 2 | stationary |
| 2022-01-01 00:20:00+00 | 2022-01-01 00:40:00+00 | 3 | in_motion |
| 2022-01-01 00:20:00+00 | 2022-01-01 00:40:00+00 | 4 | stationary |
| 2022-01-01 00:40:00+00 | 2022-01-01 01:00:00+00 | 1 | in_motion |
| 2022-01-01 00:40:00+00 | 2022-01-01 01:00:00+00 | 2 | stationary |
| 2022-01-01 00:40:00+00 | 2022-01-01 01:00:00+00 | 3 | stationary |
| 2022-01-01 00:40:00+00 | 2022-01-01 01:00:00+00 | 4 | in_motion |
| 2022-01-01 01:00:00+00 | 2022-01-01 01:20:00+00 | 1 | in_motion |
| 2022-01-01 01:00:00+00 | 2022-01-01 01:20:00+00 | 2 | stationary |
| 2022-01-01 01:00:00+00 | 2022-01-01 01:20:00+00 | 3 | stationary |
| 2022-01-01 01:00:00+00 | 2022-01-01 01:20:00+00 | 4 | in_motion |
| 2022-01-01 01:20:00+00 | 2022-01-01 01:40:00+00 | 1 | in_motion |
| 2022-01-01 01:20:00+00 | 2022-01-01 01:40:00+00 | 2 | in_motion |
| 2022-01-01 01:20:00+00 | 2022-01-01 01:40:00+00 | 3 | stationary |
| 2022-01-01 01:20:00+00 | 2022-01-01 01:40:00+00 | 4 | in_motion |
| 2022-01-01 01:40:00+00 | 2022-01-01 02:00:00+00 | 1 | stationary |
| 2022-01-01 01:40:00+00 | 2022-01-01 02:00:00+00 | 2 | in_motion |
| 2022-01-01 01:40:00+00 | 2022-01-01 02:00:00+00 | 3 | in_motion |
| 2022-01-01 01:40:00+00 | 2022-01-01 02:00:00+00 | 4 | stationary |
| 2022-01-01 02:00:00+00 | 2022-01-01 02:20:00+00 | 1 | stationary |
| 2022-01-01 02:00:00+00 | 2022-01-01 02:20:00+00 | 2 | in_motion |
| 2022-01-01 02:00:00+00 | 2022-01-01 02:20:00+00 | 3 | in_motion |
| 2022-01-01 02:00:00+00 | 2022-01-01 02:20:00+00 | 4 | in_motion |
SELECT 28