By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Type | Start | End | Result I want is |
|---|---|---|---|
| A | 01:15:00 | 01:30:00 | 01:15:00-01:45:00 |
| b | 01:45:00 | 01:50:00 | 01:45:00-01:52:00 |
| A | 01:52:00 | 01:59:00 | 01:52:00-02:00:00 |
| A | 02:00:00 | 03:00:00 | 02:00:00-03:00:00 |
SELECT 4