By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
38 rows affected
mecz | team | MP | W | D | L | GF | GA | GD | Pts | rywale |
---|---|---|---|---|---|---|---|---|---|---|
1 | null | 0 | 0 | 0 | 0 | null | null | null | 0 | Paris SG vs. Lorient |
2 | Paris SG | 1 | 1 | 0 | 0 | 3 | 1 | 2 | 3 | Paris SG vs. Brest |
3 | Paris SG | 2 | 2 | 0 | 0 | 6 | 2 | 4 | 6 | Paris SG vs. Lyon |
4 | Paris SG | 3 | 3 | 0 | 0 | 7 | 2 | 5 | 9 | Paris SG vs. Valenciennes |
5 | Paris SG | 4 | 3 | 1 | 0 | 8 | 3 | 5 | 10 | Paris SG vs. Evian Thonon Gaillard |
6 | Paris SG | 5 | 4 | 1 | 0 | 9 | 3 | 6 | 13 | Paris SG vs. Nice |
7 | Paris SG | 6 | 5 | 1 | 0 | 12 | 3 | 9 | 16 | Paris SG vs. Troyes |
8 | Paris SG | 7 | 6 | 1 | 0 | 13 | 3 | 10 | 19 | Paris SG vs. Rennes |
9 | Paris SG | 8 | 7 | 1 | 0 | 15 | 3 | 12 | 22 | Paris SG vs. Montpellier |
10 | Paris SG | 9 | 8 | 1 | 0 | 16 | 3 | 13 | 25 | Paris SG vs. St Etienne |
11 | Paris SG | 10 | 8 | 2 | 0 | 18 | 5 | 13 | 26 | Paris SG vs. Nancy |
12 | Paris SG | 11 | 9 | 2 | 0 | 20 | 6 | 14 | 29 | Paris SG vs. Reims |
13 | Paris SG | 12 | 9 | 2 | 1 | 20 | 7 | 13 | 29 | Paris SG vs. Marseille |
14 | Paris SG | 13 | 10 | 2 | 1 | 22 | 7 | 15 | 32 | Paris SG vs. Sochaux |
15 | Paris SG | 14 | 10 | 2 | 2 | 24 | 10 | 14 | 32 | Paris SG vs. Bastia |
16 | Paris SG | 15 | 11 | 2 | 2 | 27 | 11 | 16 | 35 | Paris SG vs. Toulouse |
17 | Paris SG | 16 | 12 | 2 | 2 | 31 | 11 | 20 | 38 | Paris SG vs. Lille |
18 | Paris SG | 17 | 13 | 2 | 2 | 32 | 11 | 21 | 41 | Paris SG vs. Bordeaux |
19 | Paris SG | 18 | 14 | 2 | 2 | 33 | 11 | 22 | 44 | Paris SG vs. Ajaccio |
20 | Paris SG | 19 | 14 | 3 | 2 | 33 | 11 | 22 | 45 | Paris SG vs. Brest |
21 | Paris SG | 20 | 15 | 3 | 2 | 36 | 11 | 25 | 48 | Paris SG vs. Lyon |
22 | Paris SG | 21 | 16 | 3 | 2 | 37 | 11 | 26 | 51 | Paris SG vs. Valenciennes |
23 | Paris SG | 22 | 17 | 3 | 2 | 41 | 11 | 30 | 54 | Paris SG vs. Evian Thonon Gaillard |
24 | Paris SG | 23 | 18 | 3 | 2 | 45 | 11 | 34 | 57 | Paris SG vs. Nice |
25 | Paris SG | 24 | 18 | 3 | 3 | 46 | 13 | 33 | 57 | Paris SG vs. Troyes |
26 | Paris SG | 25 | 19 | 3 | 3 | 50 | 13 | 37 | 60 | Paris SG vs. Rennes |
27 | Paris SG | 26 | 19 | 3 | 4 | 51 | 15 | 36 | 60 | Paris SG vs. Montpellier |
28 | Paris SG | 27 | 19 | 4 | 4 | 52 | 16 | 36 | 61 | Paris SG vs. St Etienne |
29 | Paris SG | 28 | 19 | 4 | 5 | 53 | 18 | 35 | 61 | Paris SG vs. Nancy |
30 | Paris SG | 29 | 20 | 4 | 5 | 54 | 18 | 36 | 64 | Paris SG vs. Reims |
31 | Paris SG | 30 | 21 | 4 | 5 | 55 | 18 | 37 | 67 | Paris SG vs. Marseille |
32 | Paris SG | 31 | 21 | 5 | 5 | 57 | 20 | 37 | 68 | Paris SG vs. Sochaux |
33 | Paris SG | 32 | 22 | 5 | 5 | 59 | 20 | 39 | 71 | Paris SG vs. Bastia |
34 | Paris SG | 33 | 23 | 5 | 5 | 63 | 20 | 43 | 74 | Paris SG vs. Toulouse |
35 | Paris SG | 34 | 24 | 5 | 5 | 65 | 20 | 45 | 77 | Paris SG vs. Lille |
36 | Paris SG | 35 | 25 | 5 | 5 | 67 | 21 | 46 | 80 | Paris SG vs. Bordeaux |
37 | Paris SG | 36 | 25 | 6 | 5 | 67 | 21 | 46 | 81 | Paris SG vs. Ajaccio |
38 | Paris SG | 37 | 25 | 7 | 5 | 67 | 21 | 46 | 82 | Paris SG vs. Lorient |
Warning: Null value is eliminated by an aggregate or other SET operation.