drop table GoalKeepers;
drop table Results;
drop table Players;
drop table Teams;

create table Teams (
    name char(40) unique,
    groupname char(1),
    teamid char(3) unique,
    coach char(50));

create table Players (
    name char(40) unique,
    teamid char(3),
    matches integer,
    totalminutes integer,
    numgoals integer,
    foreign key (teamid) references Teams(teamid)
);

create table GoalKeepers (
    name char(40) unique,
    goalsagainst integer,
    saves integer,
    foreign key (name) references Players(name)
);

create table Results (
    teamone char(3),
    teamtwo char(3),
    scoreone integer,
    scoretwo integer,
    matchdate date,
    foreign key (teamone) references Teams(teamid),
    foreign key (teamtwo) references Teams(teamid)
);

insert into Teams values('Costa Rica', 'A', 'CRC', 'GUIMARAES Alexandre');
insert into Teams values('Germany', 'A', 'GER', 'KLINSMANN Juergen');
insert into Teams values('Ecuador', 'A', 'ECU', 'SUAREZ Luis');
insert into Teams values('Poland', 'A', 'POL', 'JANAS Pawel');
insert into Teams values('Paraguay', 'B', 'PAR', 'RUIZ Anibal');
insert into Teams values('Sweden', 'B', 'SWE', 'LAGERBACK Lars');
insert into Teams values('England', 'B', 'ENG', 'ERIKSSON Sven Goran');
insert into Teams values('Trinidad and Tobago','B', 'TRI', 'BEENHAKKER Leo');
insert into Teams values('Holland', 'C', 'NED', 'VAN BASTEN Marco');
insert into Teams values('Ivory Coast','C', 'CIV', 'MICHEL Henri');
insert into Teams values('Argentina','C', 'ARG', 'PEKERMAN Jose');
insert into Teams values('Serbia and Montenegro','C', 'SCG','PETKOVIC Ilija');
insert into Teams values('Iran', 'D', 'IRN','IVANKOVIC Branko');
insert into Teams values('Portugal', 'D', 'POR','SCOLARI Luiz Felipe');
insert into Teams values('Mexico', 'D', 'MEX','LA VOLPE Ricardo');
insert into Teams values('Angola', 'D', 'ANG','DE OLIVEIRA GONCALVES Luis');
insert into Teams values('Czech Republic', 'E', 'CZE','BRUCKNER Karel');
insert into Teams values('Ghana', 'E', 'GHA','DUJKOVIC Ratomir');
insert into Teams values('Italy', 'E', 'ITA','LIPPI Marcello');
insert into Teams values('USA', 'E', 'USA','ARENA Bruce');
insert into Teams values('Croatia', 'F', 'CRO','KRANJCAR Zlatko');
insert into Teams values('Japan', 'F', 'JPN','ZICO');
insert into Teams values('Brazil', 'F', 'BRA','PARREIRA Carlos Alberto');
insert into Teams values('Australia', 'F', 'AUS','HIDDINK Guus');
insert into Teams values('Switzerland', 'G', 'SUI','KUHN Koebi');
insert into Teams values('Togo', 'G', 'TOG','PFISTER Otto');
insert into Teams values('France', 'G', 'FRA','DOMENECH Raymond');
insert into Teams values('Korea Republic', 'G', 'KOR','ADVOCAAT Dick');
insert into Teams values('Saudi Arabia', 'H', 'KSA','PAQUETA');
insert into Teams values('Ukraine', 'H', 'UKR','BLOKHIN Oleg');
insert into Teams values('Spain', 'H', 'ESP','ARAGONES Luis');
insert into Teams values('Tunisia', 'H', 'TUN','LEMERRE Roger');


insert into Players values ('KLOSE Miroslav', 'GER', 7, 582 , 5 );
insert into Players values ('CRESPO Hernan', 'ARG', 4, 305 , 3 );
insert into Players values ('RONALDO', 'BRA', 5, 409 , 3 );
insert into Players values ('ZIDANE Zinedine', 'FRA', 6, 558 , 3 );
insert into Players values ('VILLA David', 'ESP', 4, 208 , 3 );
insert into Players values ('TORRES Fernando', 'ESP', 4, 291 , 3 );
insert into Players values ('RODRIGUEZ Maxi', 'ARG', 5, 494 , 3 );
insert into Players values ('HENRY Thierry', 'FRA', 7, 632 , 3 );
insert into Players values ('PODOLSKI Lukas', 'GER', 7, 633 , 3 );
insert into Players values ('SCHWEINSTEIGER Bastian', 'GER', 7, 526 , 2 );
insert into Players values ('VIEIRA Patrick', 'FRA', 7, 585 , 2 );
insert into Players values ('DELGADO Agustin', 'ECU', 3, 262 , 2 );
insert into Players values ('SHEVCHENKO Andriy', 'UKR', 5, 472 , 2 );
insert into Players values ('DINDANE Aruna', 'CIV', 3, 155 , 2 );
insert into Players values ('BOSACKI Bartosz', 'POL', 2, 180 , 2 );
insert into Players values ('TENORIO Carlos', 'ECU', 3, 180 , 2 );
insert into Players values ('ADRIANO', 'BRA', 4, 265 , 2 );
insert into Players values ('ROSICKY Tomas', 'CZE', 3, 265 , 2 );
insert into Players values ('BRAVO Omar', 'MEX', 3, 270 , 2 );
insert into Players values ('WANCHOPE Paulo', 'CRC', 3, 270 , 2 );
insert into Players values ('CAHILL Tim', 'AUS', 4, 273 , 2 );
insert into Players values ('MATERAZZI Marco', 'ITA', 4, 363 , 2 );
insert into Players values ('FREI Alexander', 'SUI', 4, 382 , 2 );
insert into Players values ('GERRARD Steven', 'ENG', 5, 411 , 2 );
insert into Players values ('TONI Luca', 'ITA', 6, 479 , 2 );
insert into Players values ('MANICHE', 'POR', 7, 565 , 2 );
insert into Players values ('TOTTI Francesco', 'ITA', 7, 465 , 1 );
insert into Players values ('PIRLO Andrea', 'ITA', 7, 667 , 1 );
insert into Players values ('ALOISI John', 'AUS', 4, 76 , 1 );
insert into Players values ('SAVIOLA Javier', 'ARG', 3, 215 , 1 );
insert into Players values ('KALINICHENKO Maksym', 'UKR', 4, 328 , 1 );
insert into Players values ('BECKHAM David', 'ENG', 5, 407 , 1 );
insert into Players values ('MESSI Lionel', 'ARG', 3, 122 , 1 );
insert into Players values ('ALLBACK Marcus', 'SWE', 4, 167 , 1 );
insert into Players values ('KAVIEDES Ivan', 'ECU', 4, 180 , 1 );
insert into Players values ('ZINHA', 'MEX', 4, 188 , 1 );
insert into Players values ('JAZIRI Zied', 'TUN', 3, 225 , 1 );
insert into Players values ('GYAN Asamoah', 'GHA', 3, 252 , 1 );
insert into Players values ('GOMEZ Ronald', 'CRC', 3, 260 , 1 );
insert into Players values ('ROBBEN Arjen', 'NED', 3, 270 , 1 );
insert into Players values ('TEVEZ Carlos', 'ARG', 4, 288 , 1 );
insert into Players values ('GILARDINO Alberto', 'ITA', 5, 304 , 1 );
insert into Players values ('VAN PERSIE Robin', 'NED', 4, 336 , 1 );
insert into Players values ('APPIAH Stephen', 'GHA', 4, 360 , 1 );
insert into Players values ('COLE Joe', 'ENG', 5, 386 , 1 );
insert into Players values ('BARNETTA Tranquillo', 'SUI', 4, 390 , 1 );
insert into Players values ('KAKA', 'BRA', 5, 410 , 1 );
insert into Players values ('SIMAO SABROSA', 'POR', 7, 411 , 1 );
insert into Players values ('PAULETA', 'POR', 6, 430 , 1 );
insert into Players values ('RIBERY Frank', 'FRA', 7, 512 , 1 );
insert into Players values ('ZAMBROTTA Gianluca', 'ITA', 6, 600 , 1 );
insert into Players values ('FRED', 'BRA', 1, 3 , 1 );
insert into Players values ('INZAGHI Filippo', 'ITA', 1, 31 , 1 );
insert into Players values ('FLAVIO', 'ANG', 1, 40 , 1 );
insert into Players values ('KOLLER Jan', 'CZE', 1, 44 , 1 );
insert into Players values ('NUNO GOMES', 'POR', 2, 44 , 1 );
insert into Players values ('CUEVAS Nelson', 'PAR', 2, 48 , 1 );
insert into Players values ('KALOU Bonaventure', 'CIV', 2, 72 , 1 );
insert into Players values ('AL JABER Sami', 'KSA', 3, 90 , 1 );
insert into Players values ('GILBERTO', 'BRA', 1, 90 , 1 );
insert into Players values ('ILIC Sasa', 'SCG', 1, 90 , 1 );
insert into Players values ('JUANITO', 'ESP', 1, 90 , 1 );
insert into Players values ('AHN Jung Hwan', 'KOR', 3, 92 , 1 );
insert into Players values ('BAKHTIARIZADEH Sohrab', 'IRN', 2, 93 , 1 );
insert into Players values ('ZIGIC Nikola', 'SCG', 2, 111 , 1 );
insert into Players values ('TAMADA Keiji', 'JPN', 2, 120 , 1 );
insert into Players values ('KONE Bakary', 'CIV', 3, 121 , 1 );
insert into Players values ('NEUVILLE Oliver', 'GER', 7, 145 , 1 );
insert into Players values ('DEMPSEY Clint', 'USA', 2, 151 , 1 );
insert into Players values ('DRAMAN Haminu', 'GHA', 2, 169 , 1 );
insert into Players values ('AL KAHTANI Yasser', 'KSA', 2, 171 , 1 );
insert into Players values ('DEL PIERO Alessandro', 'ITA', 5, 172 , 1 );
insert into Players values ('GOLMOHAMMADI Yahya', 'IRN', 2, 177 , 1 );
insert into Players values ('REBROV Serhiy', 'UKR', 4, 178 , 1 );
insert into Players values ('RAUL', 'ESP', 4, 179 , 1 );
insert into Players values ('DROGBA Didier', 'CIV', 2, 180 , 1 );
insert into Players values ('JUNINHO PERNAMBUCANO', 'BRA', 3, 182 , 1 );
insert into Players values ('IAQUINTA Vincenzo', 'ITA', 5, 192 , 1 );
insert into Players values ('VAN NISTELROOIJ Ruud', 'NED', 3, 195 , 1 );
insert into Players values ('KEWELL Harry', 'AUS', 3, 215 , 1 );
insert into Players values ('KOVAC Niko', 'CRO', 3, 220 , 1 );
insert into Players values ('SENDEROS Philippe', 'SUI', 3, 232 , 1 );
insert into Players values ('XABI ALONSO', 'ESP', 3, 234 , 1 );
insert into Players values ('LEE Chun Soo', 'KOR', 3, 251 , 1 );
insert into Players values ('FONSECA Jose', 'MEX', 4, 266 , 1 );
insert into Players values ('SRNA Darijo', 'CRO', 3, 266 , 1 );
insert into Players values ('JAIDI Radhi', 'TUN', 3, 270 , 1 );
insert into Players values ('MNARI Jaouhar', 'TUN', 3, 270 , 1 );
insert into Players values ('MOHAMED KADER', 'TOG', 3, 270 , 1 );
insert into Players values ('MUNTARI Sulley', 'GHA', 3, 270 , 1 );
insert into Players values ('NAKAMURA Shunsuke', 'JPN', 3, 270 , 1 );
insert into Players values ('PARK Ji Sung', 'KOR', 3, 270 , 1 );
insert into Players values ('MOORE Craig', 'AUS', 4, 308 , 1 );
insert into Players values ('RUSOL Andriy', 'UKR', 4, 314 , 1 );
insert into Players values ('CROUCH Peter', 'ENG', 4, 323 , 1 );
insert into Players values ('DECO', 'POR', 4, 336 , 1 );
insert into Players values ('LARSSON Henrik', 'SWE', 4, 360 , 1 );
insert into Players values ('LJUNGBERG Fredrik', 'SWE', 4, 360 , 1 );
insert into Players values ('CAMBIASSO Esteban', 'ARG', 5, 378 , 1 );
insert into Players values ('ZE ROBERTO', 'BRA', 5, 380 , 1 );
insert into Players values ('MARQUEZ Rafael', 'MEX', 4, 390 , 1 );
insert into Players values ('CRISTIANO RONALDO', 'POR', 6, 482 , 1 );
insert into Players values ('AYALA Roberto', 'ARG', 5, 510 , 1 );
insert into Players values ('FRINGS Torsten', 'GER', 6, 539 , 1 );
insert into Players values ('GROSSO Fabio', 'ITA', 6, 600 , 1 );
insert into Players values ('LAHM Philipp', 'GER', 7, 690 , 1 );
insert into Players values ('RIQUELME Juan', 'ARG', 5, 449 , 0 );
insert into Players values ('LUIS FIGO', 'POR', 7, 528 , 0 );
insert into Players values ('CAFU', 'BRA', 4, 345 , 0 );
insert into Players values ('MENDEZ Edison', 'ECU', 4, 360 , 0 );
insert into Players values ('MENDEZ Mario', 'MEX', 4, 379 , 0 );
insert into Players values ('LUSTRINELLI Mauro', 'SUI', 2, 8 , 0 );
insert into Players values ('RICARDINHO', 'BRA', 2, 28 , 0 );
insert into Players values ('REYES Jose Antonio', 'ESP', 1, 69 , 0 );
insert into Players values ('AL HAWSAWI Malek', 'KSA', 3, 83 , 0 );
insert into Players values ('SONG Chong Gug', 'KOR', 1, 90 , 0 );
insert into Players values ('CICINHO', 'BRA', 2, 105 , 0 );
insert into Players values ('ODONKOR David', 'GER', 4, 125 , 0 );
insert into Players values ('FRANCO Guillermo', 'MEX', 3, 129 , 0 );
insert into Players values ('KEITA Kader', 'CIV', 2, 148 , 0 );
insert into Players values ('YAKIN Hakan', 'SUI', 3, 178 , 0 );
insert into Players values ('ROMAO Alaixys', 'TOG', 2, 180 , 0 );
insert into Players values ('WILTORD Sylvain', 'FRA', 7, 208 , 0 );
insert into Players values ('BEASLEY DaMarcus', 'USA', 3, 209 , 0 );
insert into Players values ('FABREGAS Cesc', 'ESP', 4, 214 , 0 );
insert into Players values ('ZURAWSKI Maciej', 'POL', 3, 217 , 0 );
insert into Players values ('NOOR Mohammed', 'KSA', 3, 240 , 0 );
insert into Players values ('ZE KALANGA', 'ANG', 3, 241 , 0 );
insert into Players values ('SANTA CRUZ Roque', 'PAR', 3, 242 , 0 );
insert into Players values ('KRZYNOWEK Jacek', 'POL', 3, 243 , 0 );
insert into Players values ('BOROWSKI Tim', 'GER', 6, 248 , 0 );
insert into Players values ('CHO Jae Jin', 'KOR', 3, 262 , 0 );
insert into Players values ('CENTENO Walter', 'CRC', 3, 263 , 0 );
insert into Players values ('BOKA Arthur', 'CIV', 3, 270 , 0 );
insert into Players values ('GRYGERA Zdenek', 'CZE', 3, 270 , 0 );
insert into Players values ('MAHDAVIKIA Mehdi', 'IRN', 3, 270 , 0 );
insert into Players values ('NEDVED Pavel', 'CZE', 3, 270 , 0 );
insert into Players values ('PUYOL Carlos', 'ESP', 3, 270 , 0 );
insert into Players values ('SANTOS Alessandro', 'JPN', 3, 270 , 0 );
insert into Players values ('STANKOVIC Dejan', 'SCG', 3, 270 , 0 );
insert into Players values ('XAVI', 'ESP', 4, 276 , 0 );
insert into Players values ('PARDO Pavel', 'MEX', 4, 307 , 0 );
insert into Players values ('VALENCIA Luis', 'ECU', 4, 314 , 0 );
insert into Players values ('LINDEROTH Tobias', 'SWE', 4, 346 , 0 );
insert into Players values ('EDMAN Erik', 'SWE', 4, 360 , 0 );
insert into Players values ('SORIN Juan', 'ARG', 4, 420 , 0 );
insert into Players values ('RONALDINHO', 'BRA', 5, 430 , 0 );
insert into Players values ('JUAN', 'BRA', 5, 450 , 0 );
insert into Players values ('BALLACK Michael', 'GER', 5, 510 , 0 );
insert into Players values ('GATTUSO Gennaro', 'ITA', 6, 552 , 0 );
insert into Players values ('SCHNEIDER Bernd', 'GER', 7, 574 , 0 );
insert into Players values ('ANDERSSON Daniel', 'SWE', 1, 1 , 0 );
insert into Players values ('AZOFEIFA Randall', 'CRC', 1, 1 , 0 );
insert into Players values ('DA SILVA Paulo', 'PAR', 1, 2 , 0 );
insert into Players values ('BEHRAMI Valon', 'SUI', 1, 3 , 0 );
insert into Players values ('BOSNJAK Ivan', 'CRO', 1, 4 , 0 );
insert into Players values ('MALM Robert', 'TOG', 1, 4 , 0 );
insert into Players values ('MADURO Hedwiges', 'NED', 1, 5 , 0 );
insert into Players values ('RASIAK Grzegorz', 'POL', 1, 6 , 0 );
insert into Players values ('BERNARD Kurt', 'CRC', 1, 7 , 0 );
insert into Players values ('VENNEGOOR OF HESSELINK Jan', 'NED', 1, 7 , 0 );
insert into Players values ('VILLAR Justo', 'PAR', 1, 7 , 0 );
insert into Players values ('DUDKA Dariusz', 'POL', 1, 8 , 0 );
insert into Players values ('ESSEDIRI Karim', 'TUN', 1, 9 , 0 );
insert into Players values ('ROGERIO CENI', 'BRA', 1, 9 , 0 );
insert into Players values ('DHORASOO Vikash', 'FRA', 2, 10 , 0 );
insert into Players values ('MASSAD Mohammed', 'KSA', 1, 10 , 0 );
insert into Players values ('BOA MORTE', 'POR', 1, 11 , 0 );
insert into Players values ('GUEMAMDIA Haykel', 'TUN', 1, 11 , 0 );
insert into Players values ('BEN SAADA Chaouki', 'TUN', 1, 12 , 0 );
insert into Players values ('HITZLSPERGER Thomas', 'GER', 1, 12 , 0 );
insert into Players values ('ONO Shinji', 'JPN', 1, 12 , 0 );
insert into Players values ('SANTOS', 'TUN', 1, 12 , 0 );
insert into Players values ('HEINZ Marek', 'CZE', 1, 13 , 0 );
insert into Players values ('KOSOWSKI Kamil', 'POL', 1, 13 , 0 );
insert into Players values ('MANZUR Julio', 'PAR', 1, 14 , 0 );
insert into Players values ('WOLFF Josh', 'USA', 1, 14 , 0 );
insert into Players values ('ASAMOAH Gerald', 'GER', 1, 18 , 0 );
insert into Players values ('BELIK Oleksiy', 'UKR', 1, 19 , 0 );
insert into Players values ('HANKE Mike', 'GER', 1, 20 , 0 );
insert into Players values ('EDSON', 'ANG', 1, 21 , 0 );
insert into Players values ('ELMANDER Johan', 'SWE', 2, 21 , 0 );
insert into Players values ('VUKIC Zvonimir', 'SCG', 1, 21 , 0 );
insert into Players values ('ODDO Massimo', 'ITA', 1, 23 , 0 );
insert into Players values ('SIONKO Libor', 'CZE', 1, 23 , 0 );
insert into Players values ('AGBOH Kuami', 'TOG', 1, 24 , 0 );
insert into Players values ('LATAPY Russell', 'TRI', 1, 24 , 0 );
insert into Players values ('JAROLIM David', 'CZE', 1, 27 , 0 );
insert into Players values ('PALACIO Rodrigo', 'ARG', 1, 27 , 0 );
insert into Players values ('LOPEZ Dante', 'PAR', 1, 28 , 0 );
insert into Players values ('MARGAIRAZ Xavier', 'SUI', 2, 29 , 0 );
insert into Players values ('YAPI YAPO Gilles', 'CIV', 1, 29 , 0 );
insert into Players values ('KIM Sang Sik', 'KOR', 2, 30 , 0 );
insert into Players values ('MODRIC Luka', 'CRO', 2, 30 , 0 );
insert into Players values ('OGURO Masashi', 'JPN', 3, 32 , 0 );
insert into Players values ('OLUFADE Adekanmi', 'TOG', 1, 32 , 0 );
insert into Players values ('SAHA Louis', 'FRA', 3, 32 , 0 );
insert into Players values ('BORHANI Arash', 'IRN', 2, 34 , 0 );
insert into Players values ('MONIWA Teruyuki', 'JPN', 1, 34 , 0 );
insert into Players values ('TACHIE-MENSAH Alex', 'GHA', 3, 34 , 0 );
insert into Players values ('YAHIA Alaeddine', 'TUN', 1, 34 , 0 );
insert into Players values ('BABEL Ryan', 'NED', 1, 35 , 0 );
insert into Players values ('CAMPBELL Sol', 'ENG', 1, 35 , 0 );
insert into Players values ('NAKATA Koji', 'JPN', 1, 35 , 0 );
insert into Players values ('RUI MARQUES', 'ANG', 2, 36 , 0 );
insert into Players values ('ARELLANO Jesus', 'MEX', 1, 39 , 0 );
insert into Players values ('BARONE Simone', 'ITA', 2, 40 , 0 );
insert into Players values ('POPOVIC Tony', 'AUS', 1, 40 , 0 );
insert into Players values ('LEWANDOWSKI Mariusz', 'POL', 2, 41 , 0 );
insert into Players values ('HERNANDEZ Carlos', 'CRC', 2, 44 , 0 );
insert into Players values ('BENITEZ Cristian', 'ECU', 1, 45 , 0 );
insert into Players values ('BORJA FeliX', 'ECU', 1, 45 , 0 );
insert into Players values ('O BRIEN John', 'USA', 1, 45 , 0 );
insert into Players values ('RODRIGUEZ Francisco', 'MEX', 1, 45 , 0 );
insert into Players values ('KENNEDY Joshua', 'AUS', 2, 46 , 0 );
insert into Players values ('URRUTIA Patricio', 'ECU', 3, 49 , 0 );
insert into Players values ('FRANCO Leonardo', 'ARG', 1, 50 , 0 );
insert into Players values ('LARA Christian', 'ECU', 2, 50 , 0 );
insert into Players values ('OLSEN Ben', 'USA', 1, 51 , 0 );
insert into Players values ('SAMUEL Collin', 'TRI', 1, 51 , 0 );
insert into Players values ('DOWNING Stewart', 'ENG', 3, 52 , 0 );
insert into Players values ('HANSSON Petter', 'SWE', 1, 52 , 0 );
insert into Players values ('BROZEK Pawel', 'POL', 3, 54 , 0 );
insert into Players values ('MANTORRAS', 'ANG', 2, 54 , 0 );
insert into Players values ('HUGO VIANA', 'POR', 2, 55 , 0 );
insert into Players values ('WISE Evans', 'TRI', 2, 56 , 0 );
insert into Players values ('AIMAR Pablo', 'ARG', 3, 57 , 0 );
insert into Players values ('GHODHBANE Kaies', 'TUN', 3, 57 , 0 );
insert into Players values ('MAKI Seiichiro', 'JPN', 1, 59 , 0 );
insert into Players values ('ASSEMOASSA Ludovic', 'TOG', 1, 61 , 0 );
insert into Players values ('ROMARIC', 'CIV', 1, 61 , 0 );
insert into Players values ('SVENSSON Anders', 'SWE', 1, 61 , 0 );
insert into Players values ('BAROS Milan', 'CZE', 1, 63 , 0 );
insert into Players values ('CRUZ Julio', 'ARG', 2, 63 , 0 );
insert into Players values ('GOVOU Sidney', 'FRA', 4, 64 , 0 );
insert into Players values ('GUARDADO Andres', 'MEX', 1, 65 , 0 );
insert into Players values ('LJUBOJA Danijel', 'SCG', 2, 65 , 0 );
insert into Players values ('MARTINEZ Gilberto', 'CRC', 1, 65 , 0 );
insert into Players values ('PARK Chu Young', 'KOR', 1, 65 , 0 );
insert into Players values ('AYOVI Marlon', 'ECU', 1, 67 , 0 );
insert into Players values ('LOVE', 'ANG', 1, 68 , 0 );
insert into Players values ('AMEEN Mohammed', 'KSA', 2, 70 , 0 );
insert into Players values ('SEOL Ki Hyeon', 'KOR', 2, 70 , 0 );
insert into Players values ('LANDZAAT Denny', 'NED', 3, 73 , 0 );
insert into Players values ('DIARRA Alou', 'FRA', 2, 75 , 0 );
insert into Players values ('JOHN Avery', 'TRI', 2, 75 , 0 );
insert into Players values ('JOHNSON Eddie', 'USA', 2, 75 , 0 );
insert into Players values ('SABORIO Alvaro', 'CRC', 2, 75 , 0 );
insert into Players values ('LEKO Jerko', 'CRO', 2, 76 , 0 );
insert into Players values ('KHATIBI Rasoul', 'IRN', 2, 77 , 0 );
insert into Players values ('KOVAC Radoslav', 'CZE', 1, 77 , 0 );
insert into Players values ('SHOJAEI Masoud', 'IRN', 1, 78 , 0 );
insert into Players values ('GYGAX Daniel', 'SUI', 2, 80 , 0 );
insert into Players values ('CHIKHAOUI Yassine', 'TUN', 1, 81 , 0 );
insert into Players values ('TOLEDO Delio', 'PAR', 1, 81 , 0 );
insert into Players values ('TOMAS Stjepan', 'CRO', 1, 82 , 0 );
insert into Players values ('DOSSEVI Thomas', 'TOG', 2, 84 , 0 );
insert into Players values ('STAJNER Jiri', 'CZE', 3, 85 , 0 );
insert into Players values ('MORALES Ramon', 'MEX', 2, 86 , 0 );
insert into Players values ('DJOUROU Johan', 'SUI', 3, 87 , 0 );
insert into Players values ('GRICHTING Stephane', 'SUI', 1, 87 , 0 );
insert into Players values ('MASTROENI Pablo', 'USA', 2, 89 , 0 );
insert into Players values ('MILEVSKIY Artem', 'UKR', 4, 89 , 0 );
insert into Players values ('ADDO Otto', 'GHA', 2, 90 , 0 );
insert into Players values ('AL HARTHI Saad', 'KSA', 1, 90 , 0 );
insert into Players values ('AMBROSI Paul', 'ECU', 1, 90 , 0 );
insert into Players values ('BADILLA Gabriel', 'CRC', 1, 90 , 0 );
insert into Players values ('BARRY Boubacar', 'CIV', 1, 90 , 0 );
insert into Players values ('BOLANOS Cristian', 'CRC', 2, 90 , 0 );
insert into Players values ('CANEIRA', 'POR', 1, 90 , 0 );
insert into Players values ('CANIZARES Santiago', 'ESP', 1, 90 , 0 );
insert into Players values ('CARRICK Michael', 'ENG', 1, 90 , 0 );
insert into Players values ('CUFRE Leandro', 'ARG', 1, 90 , 0 );
insert into Players values ('DE CLER Tim', 'NED', 1, 90 , 0 );
insert into Players values ('DOMORAUD Cyrille', 'CIV', 1, 90 , 0 );
insert into Players values ('DRAGUTINOVIC Ivica', 'SCG', 1, 90 , 0 );
insert into Players values ('HUTH Robert', 'GER', 1, 90 , 0 );
insert into Players values ('INIESTA', 'ESP', 1, 90 , 0 );
insert into Players values ('JACK Kelvin', 'TRI', 1, 90 , 0 );
insert into Players values ('JALIENS Kew', 'NED', 1, 90 , 0 );
insert into Players values ('JANSEN Marcell', 'GER', 1, 90 , 0 );
insert into Players values ('JEMMALI David', 'TUN', 1, 90 , 0 );
insert into Players values ('JOP Mariusz', 'POL', 1, 90 , 0 );
insert into Players values ('KAHN Oliver', 'GER', 1, 90 , 0 );
insert into Players values ('KALAC Zeljko', 'AUS', 1, 90 , 0 );
insert into Players values ('KOMANO Yuichi', 'JPN', 1, 90 , 0 );
insert into Players values ('KOUASSI Blaise', 'CIV', 1, 90 , 0 );
insert into Players values ('KUFFOUR Samuel', 'GHA', 1, 90 , 0 );
insert into Players values ('LOPEZ Antonio', 'ESP', 1, 90 , 0 );
insert into Players values ('MARCHENA Carlos', 'ESP', 1, 90 , 0 );
insert into Players values ('MILITO Gabriel', 'ARG', 1, 90 , 0 );
insert into Players values ('NOWOTNY Jens', 'GER', 1, 90 , 0 );
insert into Players values ('RICARDO COSTA', 'POR', 1, 90 , 0 );
insert into Players values ('SALGADO Michel', 'ESP', 1, 90 , 0 );
insert into Players values ('SHAABAN Rami', 'SWE', 1, 90 , 0 );
insert into Players values ('SILVESTRE Mikael', 'FRA', 1, 90 , 0 );
insert into Players values ('SPYCHER Christoph', 'SUI', 1, 90 , 0 );
insert into Players values ('YEZERSKYI Vladimir', 'UKR', 1, 90 , 0 );
insert into Players values ('DRUMMOND Jervis', 'CRC', 2, 94 , 0 );
insert into Players values ('AZIAWONOU Yao', 'TOG', 2, 95 , 0 );
insert into Players values ('KOROMAN Ognjen', 'SCG', 2, 97 , 0 );
insert into Players values ('POLAK Jan', 'CZE', 3, 99 , 0 );
insert into Players values ('BARRETO Edgar', 'PAR', 2, 100 , 0 );
insert into Players values ('GLEN Cornell', 'TRI', 3, 100 , 0 );
insert into Players values ('LENNON Aaron', 'ENG', 3, 104 , 0 );
insert into Players values ('PEREZ Luis', 'MEX', 2, 105 , 0 );
insert into Players values ('MILOY', 'ANG', 3, 109 , 0 );
insert into Players values ('WALLACE Harold', 'CRC', 2, 111 , 0 );
insert into Players values ('LEE Eul Yong', 'KOR', 2, 112 , 0 );
insert into Players values ('TREZEGUET David', 'FRA', 3, 112 , 0 );
insert into Players values ('OWEN Michael', 'ENG', 3, 115 , 0 );
insert into Players values ('ZANDI Ferydoon', 'IRN', 2, 116 , 0 );
insert into Players values ('FONSECA Danny', 'CRC', 2, 118 , 0 );
insert into Players values ('DOS SANTOS Julio', 'PAR', 2, 119 , 0 );
insert into Players values ('HELDER POSTIGA', 'POR', 3, 119 , 0 );
insert into Players values ('PIMPONG Razak', 'GHA', 3, 119 , 0 );
insert into Players values ('SCALONI Lionel', 'ARG', 1, 120 , 0 );
insert into Players values ('BOATENG Derek', 'GHA', 3, 121 , 0 );
insert into Players values ('BARZAGLI Andrea', 'ITA', 2, 125 , 0 );
insert into Players values ('ALBELDA David', 'ESP', 2, 126 , 0 );
insert into Players values ('KARIMI Ali', 'IRN', 2, 126 , 0 );
insert into Players values ('KHATHRAN Abdulaziz', 'KSA', 2, 126 , 0 );
insert into Players values ('STRELLER Marco', 'SUI', 3, 126 , 0 );
insert into Players values ('TOURE Assimiou', 'TOG', 2, 126 , 0 );
insert into Players values ('CONRAD Jimmy', 'USA', 2, 129 , 0 );
insert into Players values ('JONES Kenwyne', 'TRI', 2, 129 , 0 );
insert into Players values ('OLIC Ivica', 'CRO', 3, 129 , 0 );
insert into Players values ('ROTAN Ruslan', 'UKR', 3, 129 , 0 );
insert into Players values ('KEZMAN Mateja', 'SCG', 2, 130 , 0 );
insert into Players values ('DJORDJEVIC Nenad', 'SCG', 2, 132 , 0 );
insert into Players values ('GUAGUA Jorge', 'ECU', 3, 134 , 0 );
insert into Players values ('ERGIC Ivan', 'SCG', 2, 135 , 0 );
insert into Players values ('FUKUNISHI Takashi', 'JPN', 2, 135 , 0 );
insert into Players values ('GALASEK Tomas', 'CZE', 2, 135 , 0 );
insert into Players values ('INAMOTO Junichi', 'JPN', 2, 135 , 0 );
insert into Players values ('KIM Jin Kyu', 'KOR', 2, 135 , 0 );
insert into Players values ('PAPPOE Emmanuel', 'GHA', 2, 135 , 0 );
insert into Players values ('LOKVENC Vratislav', 'CZE', 2, 136 , 0 );
insert into Players values ('POPE Eddie', 'USA', 2, 136 , 0 );
insert into Players values ('AKALE Kanga', 'CIV', 3, 138 , 0 );
insert into Players values ('MILOSEVIC Savo', 'SCG', 3, 138 , 0 );
insert into Players values ('YANAGISAWA Atsushi', 'JPN', 2, 138 , 0 );
insert into Players values ('JONSON Mattias', 'SWE', 4, 140 , 0 );
insert into Players values ('SOBOLEWSKI Radoslaw', 'POL', 2, 140 , 0 );
insert into Players values ('ABALO Jean-Paul', 'TOG', 2, 142 , 0 );
insert into Players values ('CASTRO Jose Antonio', 'MEX', 2, 142 , 0 );
insert into Players values ('ROBINHO', 'BRA', 4, 143 , 0 );
insert into Players values ('AL TEMYAT Nawaf', 'KSA', 2, 144 , 0 );
insert into Players values ('OGASAWARA Mitsuo', 'JPN', 2, 145 , 0 );
insert into Players values ('TSUBOI Keisuke', 'JPN', 2, 145 , 0 );
insert into Players values ('AYARI Anis', 'TUN', 2, 146 , 0 );
insert into Players values ('BONET Carlos', 'PAR', 2, 147 , 0 );
insert into Players values ('PAULO FERREIRA', 'POR', 3, 149 , 0 );
insert into Players values ('RIVEROS Cristian', 'PAR', 2, 151 , 0 );
insert into Players values ('GONZALEZ Luis', 'ARG', 3, 152 , 0 );
insert into Players values ('KLASNIC Ivan', 'CRO', 3, 153 , 0 );
insert into Players values ('MARCOS SENNA', 'ESP', 3, 154 , 0 );
insert into Players values ('UJFALUSI Tomas', 'CZE', 2, 154 , 0 );
insert into Players values ('ZACCARDO Cristian', 'ITA', 3, 157 , 0 );
insert into Players values ('CONVEY Bobby', 'USA', 3, 158 , 0 );
insert into Players values ('GARCIA Luis', 'ESP', 3, 158 , 0 );
insert into Players values ('HEITINGA John', 'NED', 3, 159 , 0 );
insert into Players values ('JOAQUIN', 'ESP', 3, 161 , 0 );
insert into Players values ('CARRAGHER Jamie', 'ENG', 4, 163 , 0 );
insert into Players values ('LEWIS Eddie', 'USA', 2, 163 , 0 );
insert into Players values ('WILKSHIRE Luke', 'AUS', 2, 164 , 0 );
insert into Players values ('NADJ Albert', 'SCG', 3, 165 , 0 );
insert into Players values ('SENAYA Yao Junior', 'TOG', 3, 166 , 0 );
insert into Players values ('VAN DER VAART Rafael', 'NED', 3, 166 , 0);
insert into Players values ('ANDRE', 'ANG', 2, 168 , 0 );
insert into Players values ('BORGETTI Jared', 'MEX', 2, 171 , 0 );
insert into Players values ('KONE Arouna', 'CIV', 3, 176 , 0 );
insert into Players values ('DE ROSSI Daniele', 'ITA', 3, 177 , 0 );
insert into Players values ('MATEUS', 'ANG', 3, 179 , 0 );
insert into Players values ('AL GHAMDI Omar', 'KSA', 2, 180 , 0 );
insert into Players values ('BOCANEGRA Carlos', 'USA', 2, 180 , 0 );
insert into Players values ('DAEI Ali', 'IRN', 2, 180 , 0 );
insert into Players values ('DUDIC Milan', 'SCG', 2, 180 , 0 );
insert into Players values ('GRAY Cyd', 'TRI', 2, 180 , 0 );
insert into Players values ('HISLOP Shaka', 'TRI', 2, 180 , 0 );
insert into Players values ('KAJI Akira', 'JPN', 2, 180 , 0 );
insert into Players values ('KIM Dong Jin', 'KOR', 2, 180 , 0 );
insert into Players values ('KIM Young Chul', 'KOR', 2, 180 , 0 );
insert into Players values ('KOVAC Robert', 'CRO', 2, 180 , 0 );
insert into Players values ('MEITE Abdoulaye', 'CIV', 2, 180 , 0 );
insert into Players values ('MIYAMOTO Tsuneyasu', 'JPN', 2, 180 , 0 );
insert into Players values ('MOHAMED Habib', 'GHA', 2, 180 , 0 );
insert into Players values ('NEKOUNAM Javad', 'IRN', 2, 180 , 0 );
insert into Players values ('SEQUEIRA Douglas', 'CRC', 2, 180 , 0 );
insert into Players values ('SZYMKOWIAK Miroslav', 'POL', 2, 180 , 0 );
insert into Players values ('TAKAHARA Naohiro', 'JPN', 3, 180 , 0 );
insert into Players values ('TIZIE Jean-Jacques', 'CIV', 2, 180 , 0 );
insert into Players values ('TOURE Kolo', 'CIV', 2, 180 , 0 );
insert into Players values ('POBORSKY Karel', 'CZE', 3, 181 , 0 );
insert into Players values ('WHITLEY Aurtis', 'TRI', 3, 181 , 0 );
insert into Players values ('NOSRATI Mohammad', 'IRN', 3, 182 , 0 );
insert into Players values ('MADANCHI Mehrzad', 'IRN', 3, 183 , 0 );
insert into Players values ('COLOCCINI Fabricio', 'ARG', 2, 187 , 0 );
insert into Players values ('BOUAZIZI Riadh', 'TUN', 3, 188 , 0 );
insert into Players values ('NUNEZ Jorge', 'PAR', 3, 189 , 0 );
insert into Players values ('ADDO Eric', 'GHA', 4, 192 , 0 );
insert into Players values ('AZIZ Khaled', 'KSA', 3, 192 , 0 );
insert into Players values ('CHERUNDOLO Steve', 'USA', 3, 195 , 0 );
insert into Players values ('KRSTAJIC Mladen', 'SCG', 3, 195 , 0 );
insert into Players values ('NESTA Alessandro', 'ITA', 3, 196 , 0 );
insert into Players values ('AKWA', 'ANG', 3, 199 , 0 );
insert into Players values ('SVIDERSKYI Vyacheslav', 'UKR', 3, 199 , 0 );
insert into Players values ('BOULAHROUZ Khalid', 'NED', 4, 202 , 0 );
insert into Players values ('KUYT Dirk', 'NED', 3, 202 , 0 );
insert into Players values ('BURDISSO Nicolas', 'ARG', 3, 203 , 0 );
insert into Players values ('JELEN Ireneusz', 'POL', 3, 203 , 0 );
insert into Players values ('KIM Nam Il', 'KOR', 3, 203 , 0 );
insert into Players values ('EMERSON', 'BRA', 3, 206 , 0 );
insert into Players values ('IBRAHIMOVIC Zlatan', 'SWE', 3, 206 , 0 );
insert into Players values ('FORSON Richmond', 'TOG', 3, 209 , 0 );
insert into Players values ('NEVILLE Gary', 'ENG', 2, 210 , 0 );
insert into Players values ('BRESCIANO Marco', 'AUS', 4, 212 , 0 );
insert into Players values ('VASHCHUK Vladyslav', 'UKR', 3, 212 , 0 );
insert into Players values ('NAFTI Mehdi', 'TUN', 3, 215 , 0 );
insert into Players values ('VAN BOMMEL Mark', 'NED', 3, 215 , 0 );
insert into Players values ('HASHEMIAN Vahid', 'IRN', 3, 218 , 0 );
insert into Players values ('TORRADO Gerardo', 'MEX', 3, 218 , 0 );
insert into Players values ('REYNA Claudio', 'USA', 3, 219 , 0 );
insert into Players values ('WILHELMSSON Christian', 'SWE', 4, 220 , 0 );
insert into Players values ('FIGUEIREDO', 'ANG', 3, 223 , 0 );
insert into Players values ('CHEDLI Adel', 'TUN', 3, 225 , 0 );
insert into Players values ('KALLSTROM Kim', 'SWE', 4, 226 , 0 );
insert into Players values ('MATHIJSEN Joris', 'NED', 3, 230 , 0 );
insert into Players values ('KRANJCAR Niko', 'CRO', 3, 231 , 0 );
insert into Players values ('DOKHI Ahmed', 'KSA', 3, 234 , 0 );
insert into Players values ('MAMAM Cherif Toure', 'TOG', 3, 234 , 0 );
insert into Players values ('GONZALEZ Leonardo', 'CRC', 3, 235 , 0 );
insert into Players values ('KEHL Sebastian', 'GER', 4, 235 , 0 );
insert into Players values ('THEOBALD Densill', 'TRI', 3, 239 , 0 );
insert into Players values ('STERJOVSKI Mile', 'AUS', 3, 240 , 0 );
insert into Players values ('SALIFOU Moustapha', 'TOG', 3, 241 , 0 );
insert into Players values ('LEE Young Pyo', 'KOR', 3, 242 , 0 );
insert into Players values ('RADOMSKI Arkadiusz', 'POL', 3, 243 , 0 );
insert into Players values ('GILBERTO SILVA', 'BRA', 4, 244 , 0 );
insert into Players values ('VALDEZ Nelson', 'PAR', 3, 245 , 0 );
insert into Players values ('VOROBEY Andriy', 'UKR', 4, 245 , 0 );
insert into Players values ('KAABI Hossein', 'IRN', 3, 246 , 0 );
insert into Players values ('PLASIL Jaroslav', 'CZE', 3, 247 , 0 );
insert into Players values ('HURTADO Ivan', 'ECU', 3, 248 , 0 );
insert into Players values ('LEE Ho', 'KOR', 3, 248 , 0 );
insert into Players values ('TUDOR Igor', 'CRO', 3, 249 , 0 );
insert into Players values ('ROONEY Wayne', 'ENG', 4, 252 , 0 );
insert into Players values ('ADEBAYOR Emmanuel', 'TOG', 3, 254 , 0 );
insert into Players values ('CACERES Julio Cesar', 'PAR', 3, 256 , 0 );
insert into Players values ('MC BRIDE Brian', 'USA', 3, 256 , 0 );
insert into Players values ('SOLIS Mauricio', 'CRC', 3, 257 , 0 );
insert into Players values ('SULIMANI Hussein', 'KSA', 3, 260 , 0 );
insert into Players values ('ZEWLAKOW Michal', 'POL', 3, 262 , 0 );
insert into Players values ('BOBADILLA Aldo', 'PAR', 3, 263 , 0 );
insert into Players values ('TIAGO', 'POR', 5, 263 , 0 );
insert into Players values ('SIMIC Dario', 'CRO', 3, 264 , 0 );
insert into Players values ('SMOLAREK Ebi', 'POL', 3, 264 , 0 );
insert into Players values ('EMERTON Brett', 'AUS', 3, 266 , 0 );
insert into Players values ('CANIZA Denis', 'PAR', 3, 268 , 0 );
insert into Players values ('ACUNA Roberto', 'PAR', 3, 270 , 0 );
insert into Players values ('AGASSA Kossi', 'TOG', 3, 270 , 0 );
insert into Players values ('AL MONTASHARI Hamad', 'KSA', 3, 270 , 0 );
insert into Players values ('BABIC Marko', 'CRO', 3, 270 , 0 );
insert into Players values ('BAK Jacek', 'POL', 3, 270 , 0 );
insert into Players values ('BASZCZYNSKI Marcin', 'POL', 3, 270 , 0 );
insert into Players values ('BIRCHALL Christopher', 'TRI', 3, 270 , 0 );
insert into Players values ('BORUC Artur', 'POL', 3, 270 , 0 );
insert into Players values ('BOUMNIJEL Ali', 'TUN', 3, 270 , 0 );
insert into Players values ('CASILLAS Iker', 'ESP', 3, 270 , 0 );
insert into Players values ('CASTILLO Segundo', 'ECU', 3, 270 , 0 );
insert into Players values ('CECH Petr', 'CZE', 3, 270 , 0 );
insert into Players values ('CHOI Jin Cheul', 'KOR', 3, 270 , 0 );
insert into Players values ('DELGADO', 'ANG', 3, 270 , 0 );
insert into Players values ('DJORDJEVIC Predrag', 'SCG', 3, 270 , 0 );
insert into Players values ('DONOVAN Landon', 'USA', 3, 270 , 0 );
insert into Players values ('DULJAJ Igor', 'SCG', 3, 270 , 0 );
insert into Players values ('EBOUE Emmanuel', 'CIV', 3, 270 , 0 );
insert into Players values ('EDWARDS Carlos', 'TRI', 3, 270 , 0 );
insert into Players values ('ESSIEN Michael', 'GHA', 3, 270 , 0 );
insert into Players values ('GAMARRA Carlos', 'PAR', 3, 270 , 0 );
insert into Players values ('GAVRANCIC Goran', 'SCG', 3, 270 , 0 );
insert into Players values ('HAGGUI Karim', 'TUN', 3, 270 , 0 );
insert into Players values ('ISAKSSON Andreas', 'SWE', 3, 270 , 0 );
insert into Players values ('JAMBA', 'ANG', 3, 270 , 0 );
insert into Players values ('JANKULOVSKI Marek', 'CZE', 3, 270 , 0 );
insert into Players values ('JEVRIC Dragoslav', 'SCG', 3, 270 , 0 );
insert into Players values ('JOAO RICARDO', 'ANG', 3, 270 , 0 );
insert into Players values ('JOHN Stern', 'TRI', 3, 270 , 0 );
insert into Players values ('KALI', 'ANG', 3, 270 , 0 );
insert into Players values ('KARIRI Saud', 'KSA', 3, 270 , 0 );
insert into Players values ('KAWAGUCHI Yoshikatsu', 'JPN', 3, 270 , 0 );
insert into Players values ('KELLER Kasey', 'USA', 3, 270 , 0 );
insert into Players values ('LAWRENCE Dennis', 'TRI', 3, 270 , 0 );
insert into Players values ('LEE Woon Jae', 'KOR', 3, 270 , 0 );
insert into Players values ('LOCO', 'ANG', 3, 270 , 0 );
insert into Players values ('MARIN Luis', 'CRC', 3, 270 , 0 );
insert into Players values ('MENDONCA', 'ANG', 3, 270 , 0 );
insert into Players values ('MIRZAPOUR Ebrahim', 'IRN', 3, 270 , 0 );
insert into Players values ('NAKATA Hidetoshi', 'JPN', 3, 270 , 0 );
insert into Players values ('NAKAZAWA Yuji', 'JPN', 3, 270 , 0 );
insert into Players values ('NAMOUCHI Hamed', 'TUN', 3, 270 , 0 );
insert into Players values ('NIBOMBE Dare', 'TOG', 3, 270 , 0 );
insert into Players values ('ONYEWU Oguchi', 'USA', 3, 270 , 0 );
insert into Players values ('PABLO', 'ESP', 3, 270 , 0 );
insert into Players values ('PAREDES Carlos', 'PAR', 3, 270 , 0 );
insert into Players values ('PERNIA Mariano', 'ESP', 3, 270 , 0 );
insert into Players values ('PLETIKOSA Stipe', 'CRO', 3, 270 , 0 );
insert into Players values ('PORRAS Jose', 'CRC', 3, 270 , 0 );
insert into Players values ('PRSO Dado', 'CRO', 3, 270 , 0 );
insert into Players values ('RAMOS Sergio', 'ESP', 3, 270 , 0 );
insert into Players values ('REASCO Neicer', 'ECU', 3, 270 , 0 );
insert into Players values ('REZAEI Rahman', 'IRN', 3, 270 , 0 );
insert into Players values ('ROZEHNAL David', 'CZE', 3, 270 , 0 );
insert into Players values ('SANCHO Brent', 'TRI', 3, 270 , 0 );
insert into Players values ('SCHWARZER Mark', 'AUS', 3, 270 , 0 );
insert into Players values ('SIMUNIC Josip', 'CRO', 3, 270 , 0 );
insert into Players values ('TCHANGAI Massamasso', 'TOG', 3, 270 , 0 );
insert into Players values ('TEYMOURIAN Andranik', 'IRN', 3, 270 , 0 );
insert into Players values ('TOURE Yaya', 'CIV', 3, 270 , 0 );
insert into Players values ('TRABELSI Hatem', 'TUN', 3, 270 , 0 );
insert into Players values ('TUKAR Redha', 'KSA', 3, 270 , 0 );
insert into Players values ('UMANA Michael', 'CRC', 3, 270 , 0 );
insert into Players values ('VAN BRONCKHORST Giovanni', 'NED', 3, 270 , 0 );
insert into Players values ('YORKE Dwight', 'TRI', 3, 270 , 0 );
insert into Players values ('ZAID Mabrouk', 'KSA', 3, 270 , 0 );
insert into Players values ('ZOKORA Didier', 'CIV', 3, 270 , 0 );
insert into Players values ('AMOAH Matthew', 'GHA', 4, 273 , 0 );
insert into Players values ('GUSIN Andriy', 'UKR', 5, 283 , 0 );
insert into Players values ('COSTINHA', 'POR', 5, 285 , 0 );
insert into Players values ('PINEDA Gonzalo', 'MEX', 4, 290 , 0 );
insert into Players values ('MAGNIN Ludovic', 'SUI', 3, 300 , 0 );
insert into Players values ('LUCIC Teddy', 'SWE', 4, 304 , 0 );
insert into Players values ('HARGREAVES Owen', 'ENG', 4, 308 , 0 );
insert into Players values ('SNEIJDER Wesley', 'NED', 4, 314 , 0 );
insert into Players values ('SHILLA Illiasu', 'GHA', 4, 315 , 0 );
insert into Players values ('GRELLA Vince', 'AUS', 4, 332 , 0 );
insert into Players values ('ESPINOZA Giovanny', 'ECU', 4, 338 , 0 );
insert into Players values ('TENORIO Edwin', 'ECU', 4, 338 , 0 );
insert into Players values ('CHIPPERFIELD Scott', 'AUS', 4, 344 , 0 );
insert into Players values ('CAMORANESI Mauro', 'ITA', 5, 350 , 0 );
insert into Players values ('COCU Phillip', 'NED', 4, 353 , 0 );
insert into Players values ('ALEXANDERSSON Niclas', 'SWE', 4, 360 , 0 );
insert into Players values ('CULINA Jason', 'AUS', 4, 360 , 0 );
insert into Players values ('DE LA CRUZ Ulises', 'ECU', 4, 360 , 0 );
insert into Players values ('KINGSON Richard', 'GHA', 4, 360 , 0 );
insert into Players values ('MELLBERG Olof', 'SWE', 4, 360 , 0 );
insert into Players values ('MENSAH John', 'GHA', 4, 360 , 0 );
insert into Players values ('MORA Cristian', 'ECU', 4, 360 , 0 );
insert into Players values ('NEILL Lucas', 'AUS', 4, 360 , 0 );
insert into Players values ('OOIJER Andre', 'NED', 4, 360 , 0 );
insert into Players values ('PANTSIL John', 'GHA', 4, 360 , 0 );
insert into Players values ('ROBERTO CARLOS', 'BRA', 4, 360 , 0 );
insert into Players values ('VAN DER SAR Edwin', 'NED', 4, 360 , 0 );
insert into Players values ('VIDUKA Mark', 'AUS', 4, 360 , 0 );
insert into Players values ('VORONIN Andriy', 'UKR', 4, 368 , 0 );
insert into Players values ('MUELLER Patrick', 'SUI', 4, 374 , 0 );
insert into Players values ('CABANAS Ricardo', 'SUI', 4, 376 , 0 );
insert into Players values ('WICKY Raphael', 'SUI', 4, 378 , 0 );
insert into Players values ('DEGEN Philipp', 'SUI', 4, 390 , 0 );
insert into Players values ('OSORIO Ricardo', 'MEX', 4, 390 , 0 );
insert into Players values ('SALCIDO Carlos', 'MEX', 4, 390 , 0 );
insert into Players values ('SANCHEZ Oswaldo', 'MEX', 4, 390 , 0 );
insert into Players values ('VOGEL Johann', 'SUI', 4, 390 , 0 );
insert into Players values ('ZUBERBUEHLER Pascal', 'SUI', 4, 390 , 0 );
insert into Players values ('PETIT', 'POR', 6, 395 , 0 );
insert into Players values ('HEINZE Gabriel', 'ARG', 4, 420 , 0 );
insert into Players values ('GUSEV Oleg', 'UKR', 5, 435 , 0 );
insert into Players values ('SHELAYEV Oleg', 'UKR', 5, 435 , 0 );
insert into Players values ('DIDA', 'BRA', 5, 441 , 0 );
insert into Players values ('FERDINAND Rio', 'ENG', 5, 445 , 0 );
insert into Players values ('LUCIO', 'BRA', 5, 450 , 0 );
insert into Players values ('ABBONDANZIERI Roberto', 'ARG', 5, 460 , 0 );
insert into Players values ('COLE Ashley', 'ENG', 5, 480 , 0 );
insert into Players values ('LAMPARD Frank', 'ENG', 5, 480 , 0 );
insert into Players values ('NESMACHNYI Andriy', 'UKR', 5, 480 , 0 );
insert into Players values ('ROBINSON Paul', 'ENG', 5, 480 , 0 );
insert into Players values ('SHOVKOVSKYI Oleksandr', 'UKR', 5, 480 , 0 );
insert into Players values ('TERRY John', 'ENG', 5, 480 , 0 );
insert into Players values ('TYMOSCHUK Anatoliy', 'UKR', 5, 480 , 0 );
insert into Players values ('MALOUDA Florent', 'FRA', 6, 501 , 0 );
insert into Players values ('MASCHERANO Javier', 'ARG', 5, 510 , 0 );
insert into Players values ('MIGUEL', 'POR', 6, 511 , 0 );
insert into Players values ('NUNO VALENTE', 'POR', 6, 548 , 0 );
insert into Players values ('ABIDAL Eric', 'FRA', 6, 570 , 0 );
insert into Players values ('RICARDO CARVALHO', 'POR', 6, 570 , 0 );
insert into Players values ('FRIEDRICH Arne', 'GER', 6, 573 , 0 );
insert into Players values ('LEHMANN Jens', 'GER', 6, 600 , 0 );
insert into Players values ('MERTESACKER Per', 'GER', 6, 600 , 0 );
insert into Players values ('METZELDER Christoph', 'GER', 6, 600 , 0 );
insert into Players values ('PERROTTA Simone', 'ITA', 7, 613 , 0 );
insert into Players values ('BARTHEZ Fabien', 'FRA', 7, 660 , 0 );
insert into Players values ('FERNANDO MEIRA', 'POR', 7, 660 , 0 );
insert into Players values ('GALLAS William', 'FRA', 7, 660 , 0 );
insert into Players values ('MAKELELE Claude', 'FRA', 7, 660 , 0 );
insert into Players values ('RICARDO', 'POR', 7, 660 , 0 );
insert into Players values ('SAGNOL Willy', 'FRA', 7, 660 , 0 );
insert into Players values ('THURAM Lilian', 'FRA', 7, 660 , 0 );
insert into Players values ('BUFFON Gianluigi', 'ITA', 7, 690 , 0 );
insert into Players values ('CANNAVARO Fabio', 'ITA', 7, 690 , 0 );

insert into Results values ('ITA', 'FRA', 6, 4, to_date('09-07-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'POR', 3, 1, to_date('08-07-2006', 'dd-mm-yyyy'));
insert into Results values ('POR', 'FRA', 0, 1, to_date('05-07-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'ITA', 0, 2, to_date('04-07-2006', 'dd-mm-yyyy'));
insert into Results values ('BRA', 'FRA', 0, 1, to_date('01-07-2006', 'dd-mm-yyyy'));
insert into Results values ('ENG', 'POR', 1, 3, to_date('01-07-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'ARG', 5, 3, to_date('30-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ITA', 'UKR', 3, 0, to_date('30-06-2006', 'dd-mm-yyyy'));
insert into Results values ('BRA', 'GHA', 3, 0, to_date('27-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ESP', 'FRA', 1, 3, to_date('27-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ITA', 'AUS', 1, 0, to_date('26-06-2006', 'dd-mm-yyyy'));
insert into Results values ('SUI', 'UKR', 0, 3, to_date('26-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ENG', 'ECU', 1, 0, to_date('25-06-2006', 'dd-mm-yyyy'));
insert into Results values ('POR', 'NED', 1, 0, to_date('25-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ARG', 'MEX', 2, 1, to_date('24-06-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'SWE', 2, 0, to_date('24-06-2006', 'dd-mm-yyyy'));
insert into Results values ('CRC', 'POL', 1, 2, to_date('20-06-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'ECU', 3, 0, to_date('20-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ECU', 'CRC', 3, 0, to_date('15-06-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'POL', 1, 0, to_date('14-06-2006', 'dd-mm-yyyy'));
insert into Results values ('GER', 'CRC', 4, 2, to_date('09-06-2006', 'dd-mm-yyyy'));
insert into Results values ('POL', 'ECU', 0, 2, to_date('09-06-2006', 'dd-mm-yyyy'));
insert into Results values ('PAR', 'TRI', 2, 0, to_date('20-06-2006', 'dd-mm-yyyy'));
insert into Results values ('SWE', 'ENG', 2, 2, to_date('20-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ENG', 'TRI', 2, 0, to_date('15-06-2006', 'dd-mm-yyyy'));
insert into Results values ('SWE', 'PAR', 1, 0, to_date('15-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ENG', 'PAR', 1, 0, to_date('10-06-2006', 'dd-mm-yyyy'));
insert into Results values ('TRI', 'SWE', 0, 0, to_date('10-06-2006', 'dd-mm-yyyy'));
insert into Results values ('NED', 'ARG', 0, 0, to_date('21-06-2006', 'dd-mm-yyyy'));
insert into Results values ('CIV', 'SCG', 3, 2, to_date('21-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ARG', 'SCG', 6, 0, to_date('16-06-2006', 'dd-mm-yyyy'));
insert into Results values ('NED', 'CIV', 2, 1, to_date('16-06-2006', 'dd-mm-yyyy'));
insert into Results values ('SCG', 'NED', 0, 1, to_date('11-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ARG', 'CIV', 2, 1, to_date('10-06-2006', 'dd-mm-yyyy'));
insert into Results values ('IRN', 'ANG', 1, 1, to_date('21-06-2006', 'dd-mm-yyyy'));
insert into Results values ('POR', 'MEX', 2, 1, to_date('21-06-2006', 'dd-mm-yyyy'));
insert into Results values ('POR', 'IRN', 2, 0, to_date('17-06-2006', 'dd-mm-yyyy'));
insert into Results values ('MEX', 'ANG', 0, 0, to_date('16-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ANG', 'POR', 0, 1, to_date('11-06-2006', 'dd-mm-yyyy'));
insert into Results values ('MEX', 'IRN', 3, 1, to_date('11-06-2006', 'dd-mm-yyyy'));
insert into Results values ('CZE', 'ITA', 0, 2, to_date('22-06-2006', 'dd-mm-yyyy'));
insert into Results values ('GHA', 'USA', 2, 1, to_date('22-06-2006', 'dd-mm-yyyy'));
insert into Results values ('CZE', 'GHA', 0, 2, to_date('17-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ITA', 'USA', 1, 1, to_date('17-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ITA', 'GHA', 2, 0, to_date('12-06-2006', 'dd-mm-yyyy'));
insert into Results values ('USA', 'CZE', 0, 3, to_date('12-06-2006', 'dd-mm-yyyy'));
insert into Results values ('CRO', 'AUS', 2, 2, to_date('22-06-2006', 'dd-mm-yyyy'));
insert into Results values ('JPN', 'BRA', 1, 4, to_date('22-06-2006', 'dd-mm-yyyy'));
insert into Results values ('BRA', 'AUS', 2, 0, to_date('18-06-2006', 'dd-mm-yyyy'));
insert into Results values ('JPN', 'CRO', 0, 0, to_date('18-06-2006', 'dd-mm-yyyy'));
insert into Results values ('BRA', 'CRO', 1, 0, to_date('13-06-2006', 'dd-mm-yyyy'));
insert into Results values ('AUS', 'JPN', 3, 1, to_date('12-06-2006', 'dd-mm-yyyy'));
insert into Results values ('SUI', 'KOR', 2, 0, to_date('23-06-2006', 'dd-mm-yyyy'));
insert into Results values ('TOG', 'FRA', 0, 2, to_date('23-06-2006', 'dd-mm-yyyy'));
insert into Results values ('TOG', 'SUI', 0, 2, to_date('19-06-2006', 'dd-mm-yyyy'));
insert into Results values ('FRA', 'KOR', 1, 1, to_date('18-06-2006', 'dd-mm-yyyy'));
insert into Results values ('FRA', 'SUI', 0, 0, to_date('13-06-2006', 'dd-mm-yyyy'));
insert into Results values ('KOR', 'TOG', 2, 1, to_date('13-06-2006', 'dd-mm-yyyy'));
insert into Results values ('KSA', 'ESP', 0, 1, to_date('23-06-2006', 'dd-mm-yyyy'));
insert into Results values ('UKR', 'TUN', 1, 0, to_date('23-06-2006', 'dd-mm-yyyy'));
insert into Results values ('KSA', 'UKR', 0, 4, to_date('19-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ESP', 'TUN', 3, 1, to_date('19-06-2006', 'dd-mm-yyyy'));
insert into Results values ('ESP', 'UKR', 4, 0, to_date('14-06-2006', 'dd-mm-yyyy'));
insert into Results values ('TUN', 'KSA', 2, 2, to_date('14-06-2006', 'dd-mm-yyyy'));

insert into GoalKeepers values ('BUFFON Gianluigi', 2, 27);
insert into GoalKeepers values ('RICARDO', 5, 25);
insert into GoalKeepers values ('KINGSON Richard', 6, 22);
insert into GoalKeepers values ('JOAO RICARDO', 2, 21);
insert into GoalKeepers values ('KAWAGUCHI Yoshikatsu', 7, 21);
insert into GoalKeepers values ('DIDA', 2, 19);
insert into GoalKeepers values ('SHOVKOVSKYI Oleksandr', 7, 18);
insert into GoalKeepers values ('VAN DER SAR Edwin', 2, 18);
insert into GoalKeepers values ('ZUBERBUEHLER Pascal', 0, 18);
insert into GoalKeepers values ('AGASSA Kossi', 6, 17);
insert into GoalKeepers values ('ROBINSON Paul', 2, 16);
insert into GoalKeepers values ('BOBADILLA Aldo', 1, 15);
insert into GoalKeepers values ('ISAKSSON Andreas', 4, 15);
insert into GoalKeepers values ('PLETIKOSA Stipe', 3, 15);
insert into GoalKeepers values ('PORRAS Jose', 9, 15);
insert into GoalKeepers values ('ZAID Mabrouk', 7, 15);
insert into GoalKeepers values ('BARTHEZ Fabien', 3, 14);
insert into GoalKeepers values ('JEVRIC Dragoslav', 10, 14);
insert into GoalKeepers values ('BORUC Artur', 4, 13);
insert into GoalKeepers values ('LEHMANN Jens', 5, 13);
insert into GoalKeepers values ('MIRZAPOUR Ebrahim', 6, 13);
insert into GoalKeepers values ('MORA Cristian', 4, 13);
insert into GoalKeepers values ('BOUMNIJEL Ali', 6, 12);
insert into GoalKeepers values ('HISLOP Shaka', 2, 12);
insert into GoalKeepers values ('ABBONDANZIERI Roberto', 2, 11);
insert into GoalKeepers values ('SANCHEZ Oswaldo', 5, 11);
insert into GoalKeepers values ('CECH Petr', 4, 9);
insert into GoalKeepers values ('LEE Woon Jae', 4, 8);
insert into GoalKeepers values ('TIZIE Jean-Jacques', 4, 8);
insert into GoalKeepers values ('JACK Kelvin', 2, 7);
insert into GoalKeepers values ('KAHN Oliver', 1, 7);
insert into GoalKeepers values ('SCHWARZER Mark', 4, 7);
insert into GoalKeepers values ('CASILLAS Iker', 4, 6);
insert into GoalKeepers values ('CANIZARES Santiago', 0, 4);
insert into GoalKeepers values ('KELLER Kasey', 6, 4);
insert into GoalKeepers values ('BARRY Boubacar', 2, 1);
insert into GoalKeepers values ('FRANCO Leonardo', 1, 1);
insert into GoalKeepers values ('KALAC Zeljko', 2, 1);
insert into GoalKeepers values ('ROGERIO CENI', 0, 1);
insert into GoalKeepers values ('SHAABAN Rami', 0, 1);
insert into GoalKeepers values ('VILLAR Justo', 1, 0);

