drop table Driver cascade; drop table Codriver cascade; drop table Car cascade; drop table Stage cascade; drop table Rally cascade; drop table RallyStages cascade; drop table championship; drop table runs; create table Driver( DriverName varchar(20), Bloodtype varchar(3), primary key (DriverName), check (Bloodtype in('A+','A-','B+','B-','AB+','AB-','O+','O-')) ); insert into Driver values ('Sebastian Loeb','A+'); insert into Driver values ('Dani Sordo','A-'); insert into Driver values ('Nasser AlAttiya','B+'); insert into Driver values ('Mikko Hirvonen','B+'); insert into Driver values ('Thierry Neuville','B-'); insert into Driver values ('Juho Hanninen','AB+'); insert into Driver values ('Mads Ostberg','AB-'); insert into Driver values ('Sebastian Ogier','O+'); insert into Driver values ('Andreas Mikkelsen','O-'); insert into Driver values ('Daniel Oliveira','O+'); insert into Driver values ('Armindo Araujo','AB-'); insert into Driver values ('Christ Atkinson','B-'); insert into Driver values ('Petter Solberg','A+'); insert into Driver values ('Carlos Sainz','A-'); insert into Driver values ('Colin McRae','B+'); insert into Driver values ('Tommi Makinen','B+'); create table Codriver( CodriverName varchar(20), Bloodtype varchar(4), primary key (CodriverName), check (Bloodtype in('A+','A-','B+','B-','AB+','AB-','O+','O-')) ); insert into Codriver values ('Daniel Elena','A+'); insert into Codriver values ('Carlos del Barrio','A-'); insert into Codriver values ('Jarmo Lehtinen','B+'); insert into Codriver values ('Nicolas Gilsoul','B-'); insert into Codriver values ('Tomi Tuominen','AB+'); insert into Codriver values ('Maciek Szczepaniak','AB-'); insert into Codriver values ('Julian Ingrassia','O+'); insert into Codriver values ('Mikko Markkula','O-'); insert into Codriver values ('Christ Patterson','A+'); insert into Codriver values ('Luis Moya','A-'); insert into Codriver values ('Nicky Grist','B+'); create table Car( CarName varchar(20), Engine int, Manufacturer varchar(20), primary key (CarName), check (Engine>0)/*, DriverName varchar(20), CodriverName varchar(20), foreign key (DriverName) references Driver, foreign key (CodriverName) references Codriver*/ ); insert into Car values ('DS3 WRC',1598,'Citroen'); insert into Car values ('Fiesta RS WRC',1600,'Ford'); insert into Car values ('John Cooper Works',1600,'Mini'); insert into Car values ('Polo R WRC',1600,'Volkswagen'); insert into Car values ('C4 WRC',1998,'Citroen'); insert into Car values ('Focus RS WRC 09',2000,'Ford'); insert into Car values ('Impreza WRC 08',1994,'Subaru'); insert into Car values ('307 WRC',1995,'Peugeot'); insert into Car values ('Fabia WRC',1997,'Skoda'); insert into Car values ('Fabia S2000',2000,'Skoda'); create table Stage( /*Fecha date,*/ StageName varchar(20),/*Torrejon-Alcala*/ length numeric(5,2), primary key (StageName) ); insert into Stage values ('Gandesa', 7); insert into Stage values ('Pesells', 26); insert into Stage values ('Terra Alta', 44); insert into Stage values ('El Priorat 1', 45); insert into Stage values ('El Priorat 2', 45); insert into Stage values ('Santa Marina 1', 42); insert into Stage values ('Santa Marina 2', 42); insert into Stage values ('Oslo',1.92); insert into Stage values ('Opaker 1',14.92); insert into Stage values ('Finnskogen',20.92); insert into Stage values ('Kongsvinger',13.92); insert into Stage values ('Mountain',24.92); insert into Stage values ('Ringsaker',27.92); insert into Stage values ('Hamar 1',1.92); insert into Stage values ('Mountain 2',24.92); insert into Stage values ('Terranova 1',28.14); insert into Stage values ('Terranova 2',28.14); insert into Stage values ('Monte Lerno 1',28.14); insert into Stage values ('Castelsardo',14.00); insert into Stage values ('Monteolia 1',14); insert into Stage values ('Monteolia 2',14); insert into Stage values ('Gallura 1',8.24); insert into Stage values ('Strausbourg',3.64); insert into Stage values ('Hohlandsbourg 1',28.67); insert into Stage values ('Hohlandsbourg 2',28.24); insert into Stage values ('Vallee de Munster',22.16); insert into Stage values ('Soultzeren',8.24); insert into Stage values ('Pays dOrmont',43.45); insert into Stage values ('Pays dOrmont 2',43.45); insert into Stage values ('Dyfnant1',20.45); insert into Stage values ('Hafren Sweet Lamb',27.45); insert into Stage values ('Myherin',32.45); insert into Stage values ('Crychan',19.45); insert into Stage values ('Epynt',8.45); insert into Stage values ('Celtic Manor',3.45); insert into Stage values ('Walters Arena',37.45); insert into Stage values ('Rheola',23.45); insert into Stage values ('Halfway',16.45); insert into Stage values ('Kineta',20.45); insert into Stage values ('Aghia Marina',27.45); insert into Stage values ('Thiva',32.45); insert into Stage values ('Elikonas',19.45); insert into Stage values ('Ziria',8.45); insert into Stage values ('Ghymno',3.45); insert into Stage values ('Kefalari',37.45); insert into Stage values ('New Pissia',23.45); insert into Stage values ('New Loutraki',16.45); insert into Stage values ('Karlstad',1.9); insert into Stage values ('Mitandersfors',27); insert into Stage values ('Opaker',20.17); insert into Stage values ('Kirkener',19.21); insert into Stage values ('Finnskogen1',20.1); insert into Stage values ('Vargasen',24.65); insert into Stage values ('Sagen',14.24); insert into Stage values ('Lesiofors',15); insert into Stage values ('Hagfors',28); insert into Stage values ('Le Moulinon',36); insert into Stage values ('Burzet',30); insert into Stage values ('Lalouvesc',19); insert into Stage values ('St Bonnet',25); create table Rally( RallyName varchar(30), RLocation varchar(20), StartDate date, EndDate date, StageNum int, primary key (RallyName), check (StageNum>=1) ); insert into Rally values ('48 Rally Canalunya','Spain','2012/11/08', '2012/11/11',7); insert into Rally values ('Rallye France Alsace 2012','France', '2012/10/04', '2012/10/07',7); insert into Rally values ('30 Rallye Deutschland','Germany', '2012/08/24', '2012/08/26',4); insert into Rally values ('58 Acropolis Rally','Greece', '2012/05/24', '2012/05/27',9); insert into Rally values ('80 Rallye de Monte-Carlo','Monaco', '2012/01/24', '2012/01/27',4); insert into Rally values ('68 Wales Rally GB','United Kingdom', '2012/09/24', '2012/09/27',9); insert into Rally values ('60 Rally Sweden','Sweden', '2012/02/24', '2012/02/27',9); insert into Rally values ('3rd Rally Norway', 'Norway','2009/02/12','2009/02/15',8); insert into Rally values ('9º Rally d Italia Sardegna','Italy','2012/10/12','2012/10/15',7); insert into Rally values ('Rally UAH','Spain','2013/03/30','2013/04/02',1); insert into Rally values ('Rally Torrejon','Spain','2013/01/30','2013/02/02',1); insert into Rally values ('Rally Somosierra','Spain','2012/01/30','2012/02/02',1); insert into Rally values ('61 Rally Sweden','Sweden', '2013/02/24', '2013/02/27',9); insert into Rally values ('81 Rallye de Monte-Carlo','Monaco', '2013/01/24', '2013/01/27',4); insert into Rally values ('49 Rally Canalunya','Spain','2013/11/08', '2013/11/11',7); create table RallyStages( RallyName varchar(30), StageName varchar(20), stagenum int, foreign key (RallyName) references Rally, foreign key (StageName) references Stage ); insert into RallyStages values ('81 Rallye de Monte-Carlo','Le Moulinon',1); insert into RallyStages values ('81 Rallye de Monte-Carlo','Burzet',2); insert into RallyStages values ('81 Rallye de Monte-Carlo','Lalouvesc',3); insert into RallyStages values ('81 Rallye de Monte-Carlo','St Bonnet',4); insert into RallyStages values ('80 Rallye de Monte-Carlo','Le Moulinon',1); insert into RallyStages values ('80 Rallye de Monte-Carlo','Burzet',2); insert into RallyStages values ('80 Rallye de Monte-Carlo','Lalouvesc',3); insert into RallyStages values ('80 Rallye de Monte-Carlo','St Bonnet',4); insert into RallyStages values ('48 Rally Canalunya','Gandesa', 1); insert into RallyStages values ('48 Rally Canalunya','Pesells', 2); insert into RallyStages values ('48 Rally Canalunya','Terra Alta', 3); insert into RallyStages values ('48 Rally Canalunya','El Priorat 1', 4); insert into RallyStages values ('48 Rally Canalunya','El Priorat 2', 5); insert into RallyStages values ('48 Rally Canalunya','Santa Marina 1', 6); insert into RallyStages values ('48 Rally Canalunya','Santa Marina 2', 7); insert into RallyStages values ('49 Rally Canalunya','Gandesa', 1); insert into RallyStages values ('49 Rally Canalunya','Pesells', 2); insert into RallyStages values ('49 Rally Canalunya','Terra Alta', 3); insert into RallyStages values ('49 Rally Canalunya','El Priorat 1', 4); insert into RallyStages values ('49 Rally Canalunya','El Priorat 2', 5); insert into RallyStages values ('49 Rally Canalunya','Santa Marina 1', 6); insert into RallyStages values ('49 Rally Canalunya','Santa Marina 2', 7); insert into RallyStages values ('3rd Rally Norway','Oslo', 1); insert into RallyStages values ('3rd Rally Norway','Opaker 1', 2); insert into RallyStages values ('3rd Rally Norway','Finnskogen', 3); insert into RallyStages values ('3rd Rally Norway','Kongsvinger', 4); insert into RallyStages values ('3rd Rally Norway','Mountain', 5); insert into RallyStages values ('3rd Rally Norway','Ringsaker', 6); insert into RallyStages values ('3rd Rally Norway','Hamar 1', 7); insert into RallyStages values ('3rd Rally Norway','Mountain 2', 8); insert into RallyStages values ('9º Rally d Italia Sardegna','Terranova 1', 1); insert into RallyStages values ('9º Rally d Italia Sardegna','Terranova 2', 2); insert into RallyStages values ('9º Rally d Italia Sardegna','Monte Lerno 1', 3); insert into RallyStages values ('9º Rally d Italia Sardegna','Castelsardo', 4); insert into RallyStages values ('9º Rally d Italia Sardegna','Monteolia 1', 5); insert into RallyStages values ('9º Rally d Italia Sardegna','Monteolia 2', 6); insert into RallyStages values ('9º Rally d Italia Sardegna','Gallura 1', 7); insert into RallyStages values ('Rallye France Alsace 2012','Strausbourg', 1); insert into RallyStages values ('Rallye France Alsace 2012','Hohlandsbourg 1', 2); insert into RallyStages values ('Rallye France Alsace 2012','Hohlandsbourg 2', 3); insert into RallyStages values ('Rallye France Alsace 2012','Vallee de Munster', 4); insert into RallyStages values ('Rallye France Alsace 2012','Soultzeren', 5); insert into RallyStages values ('Rallye France Alsace 2012','Pays dOrmont', 6); insert into RallyStages values ('Rallye France Alsace 2012','Pays dOrmont 2', 7); insert into RallyStages values ('68 Wales Rally GB','Dyfnant1', 1); insert into RallyStages values ('68 Wales Rally GB','Hafren Sweet Lamb', 2); insert into RallyStages values ('68 Wales Rally GB','Myherin', 3); insert into RallyStages values ('68 Wales Rally GB','Crychan', 4); insert into RallyStages values ('68 Wales Rally GB','Epynt', 5); insert into RallyStages values ('68 Wales Rally GB','Celtic Manor', 6); insert into RallyStages values ('68 Wales Rally GB','Walters Arena', 7); insert into RallyStages values ('68 Wales Rally GB','Rheola', 8); insert into RallyStages values ('68 Wales Rally GB','Halfway', 9); insert into RallyStages values ('58 Acropolis Rally','Kineta', 1); insert into RallyStages values ('58 Acropolis Rally','Aghia Marina', 2); insert into RallyStages values ('58 Acropolis Rally','Thiva', 3); insert into RallyStages values ('58 Acropolis Rally','Elikonas', 4); insert into RallyStages values ('58 Acropolis Rally','Ziria', 5); insert into RallyStages values ('58 Acropolis Rally','Ghymno', 6); insert into RallyStages values ('58 Acropolis Rally','Kefalari', 7); insert into RallyStages values ('58 Acropolis Rally','New Pissia', 8); insert into RallyStages values ('58 Acropolis Rally','New Loutraki', 9); insert into RallyStages values ('60 Rally Sweden','Karlstad',1); insert into RallyStages values ('60 Rally Sweden','Mitandersfors',2); insert into RallyStages values ('60 Rally Sweden','Opaker',3); insert into RallyStages values ('60 Rally Sweden','Kirkener',4); insert into RallyStages values ('60 Rally Sweden','Finnskogen',5); insert into RallyStages values ('60 Rally Sweden','Vargasen',6); insert into RallyStages values ('60 Rally Sweden','Sagen',7); insert into RallyStages values ('60 Rally Sweden','Lesiofors',8); insert into RallyStages values ('60 Rally Sweden','Hagfors',9); insert into RallyStages values ('61 Rally Sweden','Karlstad',1); insert into RallyStages values ('61 Rally Sweden','Mitandersfors',2); insert into RallyStages values ('61 Rally Sweden','Opaker',3); insert into RallyStages values ('61 Rally Sweden','Kirkener',4); insert into RallyStages values ('61 Rally Sweden','Finnskogen',5); insert into RallyStages values ('61 Rally Sweden','Vargasen',6); insert into RallyStages values ('61 Rally Sweden','Sagen',7); insert into RallyStages values ('61 Rally Sweden','Lesiofors',8); insert into RallyStages values ('61 Rally Sweden','Hagfors',9); create table Championship( WRCYear int, DriverName varchar(20), Points int, foreign key (DriverName) references Driver ); insert into Championship values (2012,'Sebastian Loeb',100); insert into Championship values (2012,'Dani Sordo',80); insert into Championship values (2012,'Thierry Neuville',60); insert into Championship values (2012,'Nasser AlAttiya',35); insert into Championship values (2012,'Carlos Sainz',42); insert into Championship values (2012,'Colin McRae',12); insert into Championship values (2012,'Daniel Oliveira',27); insert into Championship values (2012,'Mads Ostberg',48); insert into Championship values (2012,'Christ Atkinson',7); /*insert into Championship values (2011,'Sebastian Loeb',112); insert into Championship values (2011,'Dani Sordo',80); insert into Championship values (2011,'Thierry Neuville',60); insert into Championship values (2011,'Carlos Sainz',35); insert into Championship values (2011,'Nasser AlAttiya',42); insert into Championship values (2011,'Colin McRae',12);*/ create table Runs( DriverName varchar(20), CodriverName varchar(20), CarName varchar(20), StageName varchar(20), RallyName varchar(30), Tiempo interval, Penalty interval, foreign key (DriverName) references Driver, foreign key (CodriverName) references Codriver, foreign key (CarName) references Car, foreign key (StageName) references Stage, foreign key (RallyName) references Rally ); /* INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Pesells','1:32:50','0:0:5'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','Fiesta RS WRC','Pesells','1:34:40','0:0:10'); INSERT INTO Runs VALUES ('Mikko Hirvonen','Jarmo Lehtinen','John Cooper Works','Pesells','1:33:25','0:0:20'); INSERT INTO Runs VALUES ('Thierry Neuville','Nicolas Gilsoul','Polo R WRC','Pesells','1:35:51','0:0:7'); INSERT INTO Runs VALUES ('Juho Hanninen','Tomi Tuominen','C4 WRC','Pesells','1:32:10','0:0:21'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Focus RS WRC 09','Pesells','1:32:57','0:0:12');*/ INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Karlstad','60 Rally Sweden','1:34:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Karlstad','60 Rally Sweden','1:35:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Karlstad','60 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Karlstad','60 Rally Sweden','1:31:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Karlstad','60 Rally Sweden','1:33:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Mitandersfors','60 Rally Sweden','0:31:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Mitandersfors','60 Rally Sweden','0:32:00','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Mitandersfors','60 Rally Sweden','0:32:57','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Mitandersfors','60 Rally Sweden','0:33:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Mitandersfors','60 Rally Sweden','0:33:40','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Opaker','60 Rally Sweden','0:02:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Opaker','60 Rally Sweden','0:02:55','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Opaker','60 Rally Sweden','0:03:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Opaker','60 Rally Sweden','0:03:15','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Opaker','60 Rally Sweden','0:03:07','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Kirkener','60 Rally Sweden','0:50:50','0:0:30'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Kirkener','60 Rally Sweden','0:49:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Kirkener','60 Rally Sweden','0:53:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Kirkener','60 Rally Sweden','0:52:00','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Kirkener','60 Rally Sweden','0:55:00','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Finnskogen','60 Rally Sweden','0:31:50','0:0:12'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Finnskogen','60 Rally Sweden','0:32:50','0:0:01'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Finnskogen','60 Rally Sweden','0:31:30','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Vargasen','60 Rally Sweden','0:40:50','0:0:4'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Vargasen','60 Rally Sweden','0:41:50','0:0:3'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Vargasen','60 Rally Sweden','1:00:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Vargasen','60 Rally Sweden','0:43:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Sagen','60 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Sagen','60 Rally Sweden','1:33:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Sagen','60 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Sagen','60 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Lesiofors','60 Rally Sweden','1:32:50','0:0:1'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Lesiofors','60 Rally Sweden','1:40:50','0:0:3'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Lesiofors','60 Rally Sweden','1:33:50','0:0:22'); INSERT INTO Runs VALUES ('Nasser AlAttiya','Tomi Tuominen','Fiesta RS WRC','Lesiofors','60 Rally Sweden','1:32:59','0:0:6'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Hagfors','60 Rally Sweden','0:32:50','0:0:11'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Hagfors','60 Rally Sweden','0:30:50','0:0:10'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Hagfors','60 Rally Sweden','0:31:50','0:0:5'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Hagfors','60 Rally Sweden','0:32:44','0:0:12'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Hagfors','60 Rally Sweden','0:32:14','0:0:7'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Karlstad','61 Rally Sweden','1:34:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Karlstad','61 Rally Sweden','1:35:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Karlstad','61 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Karlstad','61 Rally Sweden','1:31:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Karlstad','61 Rally Sweden','1:33:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Mitandersfors','61 Rally Sweden','0:31:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Mitandersfors','61 Rally Sweden','0:32:00','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Mitandersfors','61 Rally Sweden','0:32:57','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Mitandersfors','61 Rally Sweden','0:33:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Mitandersfors','61 Rally Sweden','0:33:40','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Opaker','61 Rally Sweden','0:02:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Opaker','61 Rally Sweden','0:02:55','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Opaker','61 Rally Sweden','0:03:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Opaker','61 Rally Sweden','0:03:15','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Opaker','61 Rally Sweden','0:03:07','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Kirkener','61 Rally Sweden','0:50:50','0:0:30'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Kirkener','61 Rally Sweden','0:49:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Kirkener','61 Rally Sweden','0:53:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Kirkener','61 Rally Sweden','0:52:00','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Kirkener','61 Rally Sweden','0:55:00','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Finnskogen','61 Rally Sweden','0:31:50','0:0:12'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Finnskogen','61 Rally Sweden','0:32:50','0:0:01'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Finnskogen','61 Rally Sweden','0:31:30','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Vargasen','61 Rally Sweden','0:40:50','0:0:4'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Vargasen','61 Rally Sweden','0:41:50','0:0:3'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Vargasen','61 Rally Sweden','1:00:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Vargasen','61 Rally Sweden','0:43:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Sagen','61 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Sagen','61 Rally Sweden','1:33:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Sagen','61 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Sagen','61 Rally Sweden','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Lesiofors','61 Rally Sweden','1:32:50','0:0:1'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Lesiofors','61 Rally Sweden','1:40:50','0:0:3'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Lesiofors','61 Rally Sweden','1:33:50','0:0:22'); INSERT INTO Runs VALUES ('Nasser AlAttiya','Tomi Tuominen','Fiesta RS WRC','Lesiofors','61 Rally Sweden','1:32:59','0:0:6'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Hagfors','61 Rally Sweden','0:32:50','0:0:11'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','Hagfors','61 Rally Sweden','0:30:50','0:0:2'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','DS3 WRC','Hagfors','61 Rally Sweden','0:31:50','0:0:5'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Hagfors','61 Rally Sweden','0:32:44','0:0:12'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Hagfors','61 Rally Sweden','0:32:14','0:0:7'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Le Moulinon','80 Rallye de Monte-Carlo','1:34:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','Fabia S2000','Le Moulinon','80 Rallye de Monte-Carlo','1:35:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','Impreza WRC 08','Le Moulinon','80 Rallye de Monte-Carlo','1:32:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Le Moulinon','80 Rallye de Monte-Carlo','1:31:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Le Moulinon','80 Rallye de Monte-Carlo','1:35:22','0:0:1'); INSERT INTO Runs VALUES ('Daniel Oliveira','Nicky Grist','C4 WRC','Le Moulinon','80 Rallye de Monte-Carlo','1:34:23','0:0:11'); INSERT INTO Runs VALUES ('Thierry Neuville','Julian Ingrassia','Fiesta RS WRC','Le Moulinon','80 Rallye de Monte-Carlo','1:33:55','0:0:15'); INSERT INTO Runs VALUES ('Colin McRae','Christ Patterson','307 WRC','Le Moulinon','80 Rallye de Monte-Carlo','1:34:50','0:0:14'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Burzet','80 Rallye de Monte-Carlo','0:31:50','0:0:0'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','Fabia S2000','Burzet','80 Rallye de Monte-Carlo','0:32:00','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','Impreza WRC 08','Burzet','80 Rallye de Monte-Carlo','0:32:57','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Burzet','80 Rallye de Monte-Carlo','0:33:50','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Burzet','80 Rallye de Monte-Carlo','0:33:40','0:0:7'); INSERT INTO Runs VALUES ('Daniel Oliveira','Nicky Grist','C4 WRC','Burzet','80 Rallye de Monte-Carlo','0:35:40','0:0:4'); INSERT INTO Runs VALUES ('Thierry Neuville','Julian Ingrassia','Fiesta RS WRC','Burzet','80 Rallye de Monte-Carlo','0:34:40','0:0:2'); INSERT INTO Runs VALUES ('Colin McRae','Christ Patterson','307 WRC','Burzet','80 Rallye de Monte-Carlo','0:33:46','0:0:8'); INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','Lalouvesc','80 Rallye de Monte-Carlo','0:02:50','0:0:1'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','Fabia S2000','Lalouvesc','80 Rallye de Monte-Carlo','0:02:55','0:0:2'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','Impreza WRC 08','Lalouvesc','80 Rallye de Monte-Carlo','0:03:50','0:0:3'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','Lalouvesc','80 Rallye de Monte-Carlo','0:03:15','0:0:7'); INSERT INTO Runs VALUES ('Daniel Oliveira','Nicky Grist','C4 WRC','Lalouvesc','80 Rallye de Monte-Carlo','0:05:07','0:0:12'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','Lalouvesc','80 Rallye de Monte-Carlo','0:04:07','0:0:11'); INSERT INTO Runs VALUES ('Thierry Neuville','Julian Ingrassia','Focus RS WRC 09','Lalouvesc','80 Rallye de Monte-Carlo','0:03:37','0:0:7'); /*INSERT INTO Runs VALUES ('Colin McRae','Christ Patterson','307 WRC','Lalouvesc','80 Rallye de Monte-Carlo','0:03:45','0:0:13');*/ INSERT INTO Runs VALUES ('Sebastian Loeb','Daniel Elena','DS3 WRC','St Bonnet','80 Rallye de Monte-Carlo','0:50:50','0:0:30'); INSERT INTO Runs VALUES ('Dani Sordo','Carlos del Barrio','DS3 WRC','St Bonnet','80 Rallye de Monte-Carlo','0:49:50','0:0:0'); INSERT INTO Runs VALUES ('Carlos Sainz','Luis Moya','Impreza WRC 08','St Bonnet','80 Rallye de Monte-Carlo','0:53:50','0:0:0'); INSERT INTO Runs VALUES ('Mads Ostberg','Maciek Szczepaniak','Fiesta RS WRC','St Bonnet','80 Rallye de Monte-Carlo','0:52:00','0:0:0'); INSERT INTO Runs VALUES ('Christ Atkinson','Mikko Markkula','John Cooper Works','St Bonnet','80 Rallye de Monte-Carlo','0:55:50','0:0:0'); /*INSERT INTO Runs VALUES ('Daniel Oliveira','Nicky Grist','C4 WRC','St Bonnet','80 Rallye de Monte-Carlo','0:55:00','0:0:0');*/ INSERT INTO Runs VALUES ('Thierry Neuville','Julian Ingrassia','Focus RS WRC 09','St Bonnet','80 Rallye de Monte-Carlo','0:54:00','0:0:0'); INSERT INTO Runs VALUES ('Colin McRae','Christ Patterson','307 WRC','St Bonnet','80 Rallye de Monte-Carlo','0:56:00','0:0:0');