CREATE TABLE coureur (
  numLicence INTEGER NOT NULL,
  nom VARCHAR(20) NOT NULL,
  prenom VARCHAR(20) NOT NULL,
  dateNaissance DATE NOT NULL,
  PRIMARY KEY  (numLicence)
);
INSERT INTO coureur (numLicence,nom,prenom,dateNaissance)
VALUES (20020511,'Borloo','Jean Louis','1951-04-07');
INSERT INTO coureur (numLicence,nom,prenom,dateNaissance)
VALUES (20022009,'Aubry','Martine','1950-08-08');
INSERT INTO coureur (numLicence,nom,prenom,dateNaissance)
VALUES (20022010,'Hulot','Nicolas','1955-04-30');
INSERT INTO coureur (numLicence,nom,prenom,dateNaissance)
VALUES (20022011,'Melanchon','Jean Luc','1951-08-19');
INSERT INTO coureur (numLicence,nom,prenom,dateNaissance)
VALUES (20022911,'Sarkozy','Nicolas','1955-01-28');

CREATE TABLE course (
  numCourse INTEGER NOT NULL,
  codePostal VARCHAR(6) NOT NULL,
  ville VARCHAR(20) NOT NULL,
  PRIMARY KEY  (numCourse)
);

INSERT INTO course (numCourse,codePostal,ville)
VALUES (200201,'34000','Montpellier');
INSERT INTO course (numCourse,codePostal,ville)
VALUES (200202,'91000','Massy');
INSERT INTO course (numCourse,codePostal,ville)
VALUES (200203,'93000','Sevran');
INSERT INTO course (numCourse,codePostal,ville)
VALUES (200204,'62000','Valenciennes');
INSERT INTO course (numCourse,codePostal,ville)
VALUES (200205,'92000','Neuilly');
INSERT INTO course (numCourse,codePostal,ville)
VALUES (200206,'59000','Lille');

CREATE TABLE resultat (
  numCourse INTEGER NOT NULL,
  numLicence INTEGER NOT NULL,
  temps TIME NOT NULL,
  rang INTEGER NOT NULL,
  PRIMARY KEY  (numCourse,numLicence)
);

INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200202,20020511,'01:20:00',6);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200202,20022009,'01:35:00',12);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200203,20022010,'01:35:00',8);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200203,20022011,'01:40:00',15);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200203,20022911,'01:55:00',20);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200204,20020511,'01:15:00',2);
INSERT INTO resultat (numCourse,numLicence,temps,rang)
VALUES (200204,20022911,'01:25:00',15);
