delete Spiel;

insert into Spiel values( 1,'Group A','9 June 2006 6:00 PM','Germany','Costa Rica','Munich',66000 );
insert into Spiel values( 2,'Group A','9 June 2006 9:00 PM','Poland','Ecuador','Gelsenkirchen',52000  );
insert into Spiel values( 3,'Group B','10 June 2006 3:00 PM','England','Paraguay','Frankfurt',48000 );
insert into Spiel values( 4,'Group B','10 June 2006 6:00 PM','Trinidad and Tobago','Sweden','Dortmund',62959  );
insert into Spiel values( 5,'Group C','10 June 2006 9:00 PM','Argentina','Côte d Ivoire','Hamburg',49480  );
insert into Spiel values( 6,'Group C','11 June 2006 3:00 PM','Serbia and Montenegro','Netherlands','Leipzig',37216  );
insert into Spiel values( 7,'Group D','11 June 2006 6:00 PM','Mexico','Iran','Nuremberg',41000  );
insert into Spiel values( 8,'Group D','11 June 2006 9:00 PM','Angola','Portugal','Cologne',45000  );
insert into Spiel values( 9,'Group E','12 June 2006 9:00 PM','Italy','Ghana','Hanover',43000  );
insert into Spiel values( 10,'Group E','12 June 2006 6:00 PM','USA','Czech Republic','Gelsenkirchen',52000  );
insert into Spiel values( 11,'Group F','13 June 2006 9:00 PM','Brazil','Croatia','Berlin',72000 );
insert into Spiel values( 12,'Group F','12 June 2006 3:00 PM','Australia','Japan','Kaiserslautern',46000  );
insert into Spiel values( 13,'Group G','13 June 2006 6:00 PM','France','Switzerland','Stuttgart',52000  );
insert into Spiel values( 14,'Group G','13 June 2006 3:00 PM','Korea Republic','Togo','Frankfurt',48000 );
insert into Spiel values( 15,'Group H','14 June 2006 3:00 PM','Spain','Ukraine','Leipzig',43000 );
insert into Spiel values( 16,'Group H','14 June 2006 6:00 PM','Tunisia','Saudi Arabia','Munich',66000 );
insert into Spiel values( 17,'Group A','14 June 2006 9:00 PM','Germany','Poland','Dortmund',65000 );
insert into Spiel values( 18,'Group A','15 June 2006 3:00 PM','Ecuador','Costa Rica','Hamburg',50000  );
insert into Spiel values( 19,'Group B','15 June 2006 6:00 PM','England','Trinidad and Tobago','Nuremberg',41000 );
insert into Spiel values( 20,'Group B','15 June 2006 9:00 PM','Sweden','Paraguay','Berlin',72000  );
insert into Spiel values( 21,'Group C','16 June 2006 3:00 PM','Argentina','Serbia and Montenegro','Gelsenkirchen',52000 );
insert into Spiel values( 22,'Group C','16 June 2006 6:00 PM','Netherlands','Côte d Ivoire','Stuttgart',52000 );
insert into Spiel values( 23,'Group D','16 June 2006 9:00 PM','Mexico','Angola','Hanover',43000 );
insert into Spiel values( 24,'Group D','17 June 2006 3:00 PM','Portugal','Iran','Frankfurt',48000 );
insert into Spiel values( 25,'Group E','17 June 2006 9:00 PM','Italy','USA','Kaiserslautern',46000  );
insert into Spiel values( 26,'Group E','17 June 2006 6:00 PM','Czech Republic','Ghana','Cologne',45000  );
insert into Spiel values( 27,'Group F','18 June 2006 6:00 PM','Brazil','Australia','Munich',66000 );
insert into Spiel values( 28,'Group F','18 June 2006 3:00 PM','Japan','Croatia','Nuremberg',41000 );
insert into Spiel values( 29,'Group G','18 June 2006 9:00 PM','France','Korea Republic','Leipzig',43000 );
insert into Spiel values( 30,'Group G','19 June 2006 3:00 PM','Togo','Switzerland','Dortmund',65000 );
insert into Spiel values( 31,'Group H','19 June 2006 9:00 PM','Spain','Tunisia','Stuttgart',52000 );
insert into Spiel values( 32,'Group H','19 June 2006 6:00 PM','Saudi Arabia','Ukraine','Hamburg',50000  );
insert into Spiel values( 33,'Group A','20 June 2006 4:00 PM','Ecuador','Germany','Berlin',72000  );
insert into Spiel values( 34,'Group A','20 June 2006 4:00 PM','Costa Rica','Poland','Hanover',43000 );
insert into Spiel values( 35,'Group B','20 June 2006 9:00 PM','Sweden','England','Cologne',45000  );
insert into Spiel values( 36,'Group B','20 June 2006 9:00 PM','Paraguay','Trinidad and Tobago','Kaiserslautern',46000 );
insert into Spiel values( 37,'Group C','21 June 2006 9:00 PM','Netherlands','Argentina','Frankfurt',48000 );
insert into Spiel values( 38,'Group C','21 June 2006 9:00 PM','Côte d Ivoire','Serbia and Montenegro','Munich',66000  );
insert into Spiel values( 39,'Group D','21 June 2006 4:00 PM','Portugal','Mexico','Gelsenkirchen',52000 );
insert into Spiel values( 40,'Group D','21 June 2006 4:00 PM','Iran','Angola','Leipzig',38000 );
insert into Spiel values( 41,'Group E','22 June 2006 4:00 PM','Czech Republic','Italy','Hamburg',50000  );
insert into Spiel values( 42,'Group E','22 June 2006 4:00 PM','Ghana','USA','Nuremberg',41000 );
insert into Spiel values( 43,'Group F','22 June 2006 9:00 PM','Japan','Brazil','Dortmund',65000 );
insert into Spiel values( 44,'Group F','22 June 2006 9:00 PM','Croatia','Australia','Stuttgart',52000 );
insert into Spiel values( 45,'Group G','23 June 2006 9:00 PM','Togo','France','Cologne',45000 );
insert into Spiel values( 46,'Group G','23 June 2006 9:00 PM','Switzerland','Korea Republic','Hanover',43000  );
insert into Spiel values( 47,'Group H','23 June 2006 4:00 PM','Saudi Arabia','Spain','Kaiserslautern',46000 );
insert into Spiel values( 48,'Group H','23 June 2006 4:00 PM','Ukraine','Tunisia','Berlin',72000  );
insert into Spiel values( 49,'Round of 16','24 June 2006 5:00 PM','Germany','Sweden','Munich',66000 );
insert into Spiel values( 50,'Round of 16','24 June 2006 9:00 PM','Argentina','Mexico','Leipzig',43000  );
insert into Spiel values( 51,'Round of 16','25 June 2006 5:00 PM','England','Ecuador','Stuttgart',52000 );
insert into Spiel values( 52,'Round of 16','25 June 2006 9:00 PM','Portugal','Netherlands','Nuremberg',41000  );
insert into Spiel values( 53,'Round of 16','26 June 2006 5:00 PM','Italy','Australia','Kaiserslautern',46000  );
insert into Spiel values( 54,'Round of 16','26 June 2006 9:00 PM','Switzerland','Ukraine','Cologne',45000 );
insert into Spiel values( 55,'Round of 16','27 June 2006 5:00 PM','Brazil','Ghana','Dortmund',65000 );
insert into Spiel values( 56,'Round of 16','27 June 2006 9:00 PM','Spain','France','Hanover',43000  );
insert into Spiel values( 57,'Quarter-finals','30 June 2006 5:00 PM','Germany','Argentina','Berlin',72000 );
insert into Spiel values( 58,'Quarter-finals','30 June 2006 9:00 PM','Italy','Ukraine','Hamburg',50000  );
insert into Spiel values( 59,'Quarter-finals','1 July 2006 5:00 PM','England','Portugal','Gelsenkirchen',52000  );
insert into Spiel values( 60,'Quarter-finals','1 July 2006 9:00 PM','Brazil','France','Frankfurt',48000 );
insert into Spiel values( 61,'Semi-Finals','4 July 2006 9:00 PM','Germany','Italy','Dortmund',65000 );
insert into Spiel values( 62,'Semi-Finals','5 July 2006 9:00 PM','Portugal','France','Munich',66000 );
insert into Spiel values( 63,'Third Place','8 July 2006 9:00 PM','Germany','Portugal','Stuttgart',52000 );
insert into Spiel values( 64,'Final','9 July 2006 8:00 PM','Italy','France','Berlin',69000  );