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 |