By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Date | Status |
|---|---|---|
| 1 | 2020-11-02 15:00:00 | New |
| 1 | 2020-11-02 15:00:00 | New_Step |
| 1 | 2020-11-02 15:05:00 | Start |
| 1 | 2020-11-02 15:05:00 | Stop |
| 1 | 2020-11-02 15:10:00 | Start |
| 1 | 2020-11-02 15:15:00 | Transferred |
| 1 | 2020-11-02 15:20:00 | Stop |
| 1 | 2020-11-02 16:25:00 | End |
| 2 | 2020-11-02 16:00:00 | New |
| 2 | 2020-11-02 16:00:00 | Start |
| 2 | 2020-11-02 16:05:00 | Stop |
| 2 | 2020-11-02 16:10:00 | Start |
| 2 | 2020-11-02 16:15:00 | Stop |
| 2 | 2020-11-02 16:20:00 | Start |
| 2 | 2020-11-02 16:25:00 | New_Step |
| 2 | 2020-11-02 16:30:00 | Transferred |
| 2 | 2020-11-02 16:35:00 | End |
| ID | CONCAT(5 * COUNT(`Date`) - 5, ' min') |
|---|---|
| 1 | 15 min |
| 2 | 25 min |