By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | NEXT_ID | TRAIN_ID | DATE_START | DATE_END |
|---|---|---|---|---|
| 1 | 2 | 5 | 2019-11-06 05:00:00 | 2019-11-06 07:40:00 |
| 2 | 3 | 5 | 2019-11-06 08:00:00 | 2019-11-06 09:00:00 |
| 3 | 4 | 5 | 2019-11-06 10:00:00 | 2019-11-06 10:15:00 |
| 4 | 5 | 5 | 2019-11-06 23:05:00 | 2019-11-07 00:15:00 |
| 5 | 6 | 5 | 2019-11-07 02:05:00 | 2019-11-07 04:30:00 |
| 6 | 7 | 5 | 2019-11-07 05:05:00 | 2019-11-07 07:05:00 |
| 7 | 8 | 5 | 2019-11-07 09:05:00 | 2019-11-07 10:05:00 |
| 8 | null | 5 | 2019-11-07 12:05:00 | 2019-11-07 14:05:00 |
| 9 | 10 | 6 | 2019-11-06 06:00:00 | 2019-11-06 07:40:00 |
| 10 | 11 | 6 | 2019-11-06 09:00:00 | 2019-11-06 09:50:00 |
| 11 | 12 | 6 | 2019-11-06 12:00:00 | 2019-11-06 13:15:00 |
| 12 | null | 6 | 2019-11-06 14:05:00 | 2019-11-07 00:15:00 |
| ID | NEXT_ID | TRAIN_ID | DATE_START | DATE_END | next_start | delta |
|---|---|---|---|---|---|---|
| 1 | 2 | 5 | 2019-11-06 05:00:00 | 2019-11-06 07:40:00 | 2019-11-06 08:00:00 | 00:20:00 |
| 2 | 3 | 5 | 2019-11-06 08:00:00 | 2019-11-06 09:00:00 | 2019-11-06 10:00:00 | 01:00:00 |
| 3 | 4 | 5 | 2019-11-06 10:00:00 | 2019-11-06 10:15:00 | 2019-11-06 23:05:00 | 12:50:00 |
| 4 | 5 | 5 | 2019-11-06 23:05:00 | 2019-11-07 00:15:00 | 2019-11-07 02:05:00 | 01:50:00 |
| 5 | 6 | 5 | 2019-11-07 02:05:00 | 2019-11-07 04:30:00 | 2019-11-07 05:05:00 | 00:35:00 |
| 6 | 7 | 5 | 2019-11-07 05:05:00 | 2019-11-07 07:05:00 | 2019-11-07 09:05:00 | 02:00:00 |
| 7 | 8 | 5 | 2019-11-07 09:05:00 | 2019-11-07 10:05:00 | 2019-11-07 12:05:00 | 02:00:00 |
| 8 | null | 5 | 2019-11-07 12:05:00 | 2019-11-07 14:05:00 | null | null |
| 9 | 10 | 6 | 2019-11-06 06:00:00 | 2019-11-06 07:40:00 | 2019-11-06 09:00:00 | 01:20:00 |
| 10 | 11 | 6 | 2019-11-06 09:00:00 | 2019-11-06 09:50:00 | 2019-11-06 12:00:00 | 02:10:00 |
| 11 | 12 | 6 | 2019-11-06 12:00:00 | 2019-11-06 13:15:00 | 2019-11-06 14:05:00 | 00:50:00 |
| 12 | null | 6 | 2019-11-06 14:05:00 | 2019-11-07 00:15:00 | null | null |