By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Type | Start | result |
|---|---|---|
| A | 02:02:00 | 02:02:00-02:10:00 |
| A | 02:10:00 | 02:02:00-02:17:00 |
| A | 02:17:00 | 02:02:00-02:30:00 |
| B | 02:30:00 | 02:30:00-02:46:00 |
| A | 02:46:00 | 02:46:00-03:00:00 |
| A | 03:00:00 | 02:46:00-04:00:00 |
| A | 04:00:00 | 02:46:00-end |
SELECT 7