By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | ign | sp | time |
|---|---|---|---|
| 1 | 1 | 25 | 10:00:00 |
| 2 | 1 | 22 | 10:01:00 |
| 3 | 1 | 0 | 10:02:00 |
| 4 | 1 | 0 | 10:03:00 |
| 5 | 1 | 0 | 10:04:00 |
| 6 | 1 | 0 | 10:05:00 |
| 7 | 1 | 0 | 10:06:00 |
| 8 | 1 | 8 | 10:07:00 |
| 9 | 1 | 25 | 10:08:00 |
| 10 | 1 | 22 | 10:09:00 |
| 11 | 1 | 0 | 10:10:00 |
| 12 | 1 | 0 | 10:11:00 |
| 13 | 1 | 0 | 10:12:00 |
| 14 | 1 | 0 | 10:13:00 |
| 15 | 1 | 8 | 10:14:00 |
| 16 | 1 | 10 | 10:15:00 |
| time_from | time_till |
|---|---|
| 10:02:00 | 10:06:00 |
| 10:10:00 | 10:13:00 |
| Id | ign | sp | time | @prev:=-1 | @group:=0 | group_num | @prev:=sp |
|---|---|---|---|---|---|---|---|
| 1 | 1 | 25 | 10:00:00 | -1 | 0 | 0 | 25 |
| 2 | 1 | 22 | 10:01:00 | -1 | 0 | 0 | 22 |
| 3 | 1 | 0 | 10:02:00 | -1 | 0 | 1 | 0 |
| 4 | 1 | 0 | 10:03:00 | -1 | 0 | 1 | 0 |
| 5 | 1 | 0 | 10:04:00 | -1 | 0 | 1 | 0 |
| 6 | 1 | 0 | 10:05:00 | -1 | 0 | 1 | 0 |
| 7 | 1 | 0 | 10:06:00 | -1 | 0 | 1 | 0 |
| 8 | 1 | 8 | 10:07:00 | -1 | 0 | 1 | 8 |
| 9 | 1 | 25 | 10:08:00 | -1 | 0 | 1 | 25 |
| 10 | 1 | 22 | 10:09:00 | -1 | 0 | 1 | 22 |
| 11 | 1 | 0 | 10:10:00 | -1 | 0 | 2 | 0 |
| 12 | 1 | 0 | 10:11:00 | -1 | 0 | 2 | 0 |
| 13 | 1 | 0 | 10:12:00 | -1 | 0 | 2 | 0 |
| 14 | 1 | 0 | 10:13:00 | -1 | 0 | 2 | 0 |
| 15 | 1 | 8 | 10:14:00 | -1 | 0 | 2 | 8 |
| 16 | 1 | 10 | 10:15:00 | -1 | 0 | 2 | 10 |