Sample of data stored in table vPointsGoals
TID |
G |
T |
PTS |
GAIN |
LOSS |
GDIFF |
0 |
A |
BRA |
3 |
3 |
0 |
3 |
0 |
A |
BRA |
3 |
2 |
1 |
1 |
0 |
A |
MAR |
1 |
2 |
2 |
0 |
0 |
A |
NOR |
3 |
2 |
1 |
1 |
0 |
A |
NOR |
1 |
1 |
1 |
0 |
0 |
A |
SCO |
0 |
0 |
3 |
-3 |
0 |
B |
AUT |
1 |
1 |
1 |
0 |
0 |
B |
AUT |
0 |
1 |
2 |
-1 |
0 |
B |
CHL |
1 |
1 |
1 |
0 |
0 |
B |
CMR |
1 |
1 |
1 |
0 |
0 |
B |
ITA |
1 |
2 |
2 |
0 |
0 |
B |
ITA |
3 |
3 |
0 |
3 |
0 |
C |
DNK |
0 |
1 |
2 |
-1 |
0 |
C |
FRA |
3 |
3 |
0 |
3 |
0 |
C |
SAU |
0 |
0 |
1 |
-1 |
0 |
C |
SAU |
0 |
0 |
4 |
-4 |
0 |
C |
ZAF |
1 |
1 |
1 |
0 |
0 |
C |
ZAF |
1 |
2 |
2 |
0 |
0 |
D |
BGR |
0 |
1 |
6 |
-5 |
0 |
D |
ESP |
0 |
2 |
3 |
-1 |
0 |
D |
NGA |
3 |
1 |
0 |
1 |
0 |
D |
NGA |
0 |
1 |
3 |
-2 |
0 |
D |
PRY |
1 |
0 |
0 |
0 |
0 |
D |
PRY |
1 |
0 |
0 |
0 |
0 |
E |
BEL |
1 |
1 |
1 |
0 |
0 |
E |
BEL |
1 |
2 |
2 |
0 |
0 |
E |
KOR |
0 |
1 |
3 |
-2 |
0 |
E |
KOR |
0 |
0 |
5 |
-5 |
0 |
E |
MEX |
1 |
2 |
2 |
0 |
0 |
E |
NLD |
1 |
0 |
0 |
0 |
0 |
F |
DEU |
3 |
2 |
0 |
2 |
0 |
F |
IRN |
0 |
0 |
2 |
-2 |
0 |
F |
USA |
0 |
1 |
2 |
-1 |
0 |
F |
USA |
0 |
0 |
1 |
-1 |
0 |
F |
YUG |
1 |
2 |
2 |
0 |
0 |
F |
YUG |
3 |
1 |
0 |
1 |
0 |
G |
COL |
0 |
0 |
2 |
-2 |
0 |
G |
COL |
3 |
1 |
0 |
1 |
0 |
G |
ENG |
0 |
1 |
2 |
-1 |
0 |
G |
ENG |
3 |
2 |
0 |
2 |
0 |
G |
ROU |
3 |
1 |
0 |
1 |
0 |
G |
TUN |
1 |
1 |
1 |
0 |
0 |
H |
ARG |
3 |
5 |
0 |
5 |
0 |
H |
ARG |
3 |
1 |
0 |
1 |
0 |
H |
HRV |
0 |
0 |
1 |
-1 |
0 |
H |
HRV |
3 |
1 |
0 |
1 |
0 |
H |
JAM |
0 |
1 |
3 |
-2 |
0 |
H |
JPN |
0 |
1 |
2 |
-1 |
1 |
A |
DNK |
3 |
2 |
0 |
2 |
1 |
A |
DNK |
1 |
1 |
1 |
0 |