use loueur;
set sql_safe_updates=0;
--
drop table if exists maintenance;
drop table if exists location;
drop table if exists voiture;
drop table if exists proprietaire;
drop table if exists client;
--
CREATE TABLE `loueur`.`client` (
  `codeC` VARCHAR(4) NOT NULL,
  `nom` VARCHAR(20) NOT NULL,
  `prenom` VARCHAR(20) NULL,
  `age` INT NULL,
  `permis` VARCHAR(10) NULL,
  `adresse` VARCHAR(50) NULL,
  `ville` VARCHAR(20) NULL,
  PRIMARY KEY (`codeC`) );
--  
CREATE TABLE `loueur`.`proprietaire` (
  `codeP` VARCHAR(4) NOT NULL,
  `pseudo` VARCHAR(20) NOT NULL,
  `email` VARCHAR(20) NULL,
  `ville` VARCHAR(20) NULL,
  `anneeI` VARCHAR(4) NULL,
  PRIMARY KEY (`codeP`) );
--  
CREATE TABLE `loueur`.`voiture` (
  `immat` VARCHAR(10) NOT NULL,
  `modele` VARCHAR(20) NULL,
  `marque` VARCHAR(20) NULL,
  `categorie` VARCHAR(20) NULL,
  `couleur` ENUM('blanc','rouge','vert','noir','violet','bleu'),
  `places` INT NULL CHECK (places <= 7),
  `achatA` VARCHAR(4) NULL,
  `compteur` INT NOT NULL,
  `prixJ` INT NULL,
  `codeP` VARCHAR(4) NULL,
  PRIMARY KEY (`immat`),
   INDEX `F_voit1_idx` (`codeP` ASC),
   CONSTRAINT `codeP` FOREIGN KEY (`codeP`)
		REFERENCES `loueur`.`proprietaire` (`codeP`)
		ON DELETE CASCADE
		ON UPDATE NO ACTION );
-- 
CREATE TABLE `loueur`.`location` (
  `codeC` VARCHAR(4) NOT NULL,
  `immat` VARCHAR(10) NOT NULL,
  `annee` VARCHAR(4) NOT NULL,
  `mois` VARCHAR(2) NOT NULL,
  `numLoc` VARCHAR(5) NULL,
  `km` INT NOT NULL,
  `duree` INT NULL,
  `villeD` VARCHAR(20) NULL,
  `villeA` VARCHAR(20) NULL,
  `dateD` DATE NULL,
  `dateF` DATE NULL,
  PRIMARY KEY (`codeC`, `immat`, `annee`, `mois`),
   INDEX `F_loc1_idx` (`codeC` ASC),
   INDEX `F_loc2_idx` (`immat` ASC),
   INDEX `F_loc3_idx` (`numLoc` ASC),
   CONSTRAINT `codeC` FOREIGN KEY (`codeC`)
		REFERENCES `loueur`.`client` (`codeC`)
		ON DELETE CASCADE
		ON UPDATE NO ACTION,
  CONSTRAINT `immat` FOREIGN KEY (`immat`)
		REFERENCES `loueur`.`voiture` (`immat`)
		ON DELETE CASCADE
		ON UPDATE NO ACTION  );
/*
delete from location;
delete from voiture ;
delete from proprietaire ;
delete from client ;
*/
--
-- (19) insertion dans la table client  
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C654','Juniot','Gérard',45,'2348653','rue du colisée','Paris');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C655','Delon','Alain',37,'5672821','rue des tuiles','Nantes');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C656','Auteuil','Daniel',53,'757665','rue des plantes','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C657','Gabin','Jean',67,'34567','rue Descartes','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C658','Reno','Jean',55,'2348653','rue leonard','Paris');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C659','Delon','Gerard',67,null,'rue internationale','Nantes');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C660','Depardieu','Gerard',52,'757665','rue Hollande','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C661','Depardieu','Philippe',47,'34567','rue grande','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C662','Depardieu','Julie',25,'2348653','rue des ours','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C663','Dujardin','Jean-claude',40,null,'rue aux ours','Nantes');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C664','Boon',null,42,'757665','rue des tulipes','Marseille');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C665','Willis','Bruce',47,'34567','rue de Gaulle','Marseille');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C666','Cassel','Vincent',45,'2348653','rue Vinci','Paris');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C667','Charlot',null,77,'5672821','rue du fond','Nantes');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C668','Canet','Guillaume',33,'757665','rue Verte','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C669','Richard','Pierre',53,'34567','rue Fermat','Lyon');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C670','Canet','Jean-Paul',33,'75235','rue de la daurade','Marseille');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C671','Premier','Jean-Pierre',63,'34354','rue Saint-Pierre','Vatican');
INSERT INTO `loueur`.`client` (`codeC`,`nom`,`prenom`,`age`,`permis`,`adresse`,`ville`) VALUES ('C672','Richard',NULL,57,'346767','rue des amis','Lyon');-
--
-- (13) insertion dans la table proprietaire
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P75','Lucien','L67@gmail.com','Montreuil','2005');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P89','Marcel','bozo@gmail.com','Lyon','2010');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P12','Jules','juju@hotmai.com','Paris','2014');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P37','Georges','gigi@','Neuilly','2015');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P14','Fred',null,'Paris','2008');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P23','Germain','Gi67@gmail.com','Nantes','2011');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P44','Antoine','optic2000@hotmai.com','Marseille','2014');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P61','Fernand','raynaud@','Neuilly','2013');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P74','Emile','L67@gmail.com','Nantes','2012');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P99','Marcel',null,'Paris','2010');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P19','Christian','juju@hotmai.com','Paris','2013');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P35','Serge','gigi@','Neuilly','2011');
INSERT INTO `loueur`.`proprietaire` (`codeP`,`pseudo`,`email`,`ville`,`anneeI`) VALUES ('P92','Marcel','marcou@gmail.com','Nantes','2010');
--
-- (20) insertion dans la table voiture
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('75AZ92','205','Peugeot','cabriolet','blanc',2,'2010',17560,30,'P75');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('42RS75','megane','Renault','premium','vert',4,'2010',4563,30,'P89');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('56AA46','C4','Citroen','familiale','blanc',6,'2000',8654,30,'P12');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('11TR62','Clio','Renault','luxe','rouge',2,'1998',87230,30,'P75');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('71BB37','C4','Citroen','familiale','noir',4,'2012',1258,30,'P37');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('69AZ92','205','Peugeot','berline','blanc',2,'2010',2987,30,'P75');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('32RS75','306','Peugeot','cabriolet','vert',4,'2010',4533,30,'P61');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('90AA46','508','Peugeot','familiale','blanc',6,'2000',7654,30,'P14');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('23TR62','404','Peugeot','premium','rouge',2,'1998',8720,30,'P99');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('75BB37','Twingo','Renault','citadine','noir',4,'2011',9858,30,'P99');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('87AZ92','Zoe','Renault','citadine','blanc',2,'2010',37520,30,'P75');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('11RS75','Twingo','Renault','premium','vert',4,'2009',8563,30,'P44');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('23AA46','Espace','Renault','familiale','blanc',6,'2014',8333,30,'P19');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('11FG62','Clio','Renault','luxe','rouge',2,'1998',81230,30,'P19');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('71RT37','F530','Ferrari','cabriolet','rouge',2,'2013',2358,30,'P23');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('42RL75','T550','Ferrari','cabriolet','vert',2,'2013',46563,30,'P89');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('56ER46','model S','Tesla','berline','blanc',4,'2015',854,30,'P35');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('11UI62','Clio','Renault','luxe','rouge',2,'2005',4536,30,'P23');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('71PO37','Caravan','Dodge','familiale','blanc',7,'2012',234258,30,'P61');
INSERT INTO `loueur`.`voiture` (`immat`,`modele`,`marque`,`categorie`,`couleur`,`places`,`achatA`,`compteur`,`prixJ`,`codeP`) VALUES ('39YC59','C35','Citroen','utilitaire','blanc','2','2002','67980',42,'P61');
--
-- (9) insertion dans la table location
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C654','75AZ92','2015','4','A-125',70,3,'Montreuil','Montreuil',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C655','42RL75','2015','4','A-126',678,7,'Lyon','lyon',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C656','56AA46','2015','4','B-236',59,1,'Paris','Paris',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C657','11TR62','2015','4','B-237',125,2,'Montreuil','Montreuil',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C656','42RL75','2015','4','C-45',253,4,'Lyon','Lyon',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C655','71BB37','2015','4','C-34',86,3,'Neuilly','Neuilly',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','75AZ92','2017','2','C-35',386,8,'Courbevoie','Neuilly',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C662','71BB37','2015','5','C-36',816,8,'Neuilly','Neuilly',NULL,NULL);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','75AZ92','2016','5','C-37',45,2,'Paris','Lyon',NULL,NULL);
--
-- (124) complément d'insertions dans la table location
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C654','11FG62','2015','4','C-45',37,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C654','11FG62','2015','6','B-260',37,0,'Neuilly','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C655','11RS75','2015','4','C-46',876,0,'Montreuil','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C655','11RS75','2015','6','B-261',876,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C656','11TR62','2015','4','C-47',456,0,'Neuilly','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C656','11TR62','2015','6','B-262',456,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C657','11UI62','2015','4','C-48',23,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C657','11UI62','2015','6','B-263',23,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C658','23AA46','2015','4','C-49',345,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C658','23AA46','2015','6','B-264',345,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C659','23TR62','2015','4','C-50',987,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C659','23TR62','2015','6','B-265',987,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C660','32RS75','2015','4','C-51',45,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C660','32RS75','2015','6','B-266',45,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C662','39YC59','2015','4','C-52',87,0,'Montreuil','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C662','39YC59','2015','6','B-267',87,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','11FG62','2015','5','B-237',229,0,'Neuilly','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','11FG62','2015','6','B-279',336,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','42RL75','2015','4','C-53',765,0,'Neuilly','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','42RL75','2015','6','B-268',765,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','56ER46','2015','5','B-247',88,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C663','56ER46','2015','6','B-289',140,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','11RS75','2015','5','B-238',400,0,'Lyon','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','11RS75','2015','6','B-280',263,0,'Neuilly','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','42RS75','2015','4','C-54',13,0,'Lyon','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','42RS75','2015','6','B-269',13,0,'Neuilly','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','56ER46','2015','3','A-136',228,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','56ER46','2015','6','B-314',378,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','69AZ92','2015','5','B-248',326,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C664','69AZ92','2015','6','B-290',70,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','11FG62','2015','5','B-249',436,0,'Paris','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','11FG62','2015','6','B-291',173,0,'Lyon','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','11TR62','2015','5','B-239',202,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','11TR62','2015','6','B-281',129,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','56ER46','2015','4','C-55',124,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C665','56ER46','2015','6','B-270',124,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11FG62','2015','3','A-126',297,0,'Neuilly','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11FG62','2015','6','B-304',119,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11RS75','2015','5','B-250',181,0,'Paris','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11RS75','2015','6','B-292',203,0,'Nantes','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11UI62','2015','5','B-240',97,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','11UI62','2015','6','B-282',209,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','56ER46','2015','4','A-148',191,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','69AZ92','2015','3','A-137',362,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','69AZ92','2015','4','C-56',234,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C666','69AZ92','2015','6','B-271',234,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11FG62','2015','4','A-138',159,0,'Paris','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11RS75','2015','3','A-127',176,0,'Lyon','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11RS75','2015','6','B-305',254,0,'Neuilly','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11TR62','2015','4','A-155',244,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11TR62','2015','5','B-251',329,0,'Montreuil','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11TR62','2015','6','B-293',125,0,'Nantes','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','11UI62','2015','4','A-141',416,0,'Neuilly','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','23AA46','2015','3','A-130',358,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','23AA46','2015','5','B-241',418,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','23AA46','2015','6','B-283',118,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','23TR62','2015','5','B-254',331,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','23TR62','2015','6','B-296',213,0,'Neuilly','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','32RS75','2015','4','A-144',413,0,'Paris','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','39YC59','2015','3','A-133',146,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','39YC59','2015','5','B-244',103,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','39YC59','2015','6','B-286',349,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','42RL75','2015','5','B-257',348,0,'Paris','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','42RL75','2015','6','B-299',353,0,'Nantes','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','69AZ92','2015','4','A-149',247,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','71BB37','2015','4','C-57',213,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','71BB37','2015','6','B-272',213,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','75AZ92','2015','4','C-60',765,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','75AZ92','2015','6','B-275',765,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11FG62','2015','4','A-153',54,0,'Montreuil','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11RS75','2015','4','A-139',105,0,'Paris','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11TR62','2015','3','A-128',54,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11TR62','2015','6','B-306',399,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11UI62','2015','4','A-156',56,0,'Montreuil','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11UI62','2015','5','B-252',340,0,'Neuilly','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','11UI62','2015','6','B-294',344,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','23AA46','2015','4','A-142',147,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','23TR62','2015','3','A-131',277,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','23TR62','2015','5','B-242',394,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','23TR62','2015','6','B-284',60,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','32RS75','2015','5','B-255',267,0,'Montreuil','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','32RS75','2015','6','B-297',128,0,'Lyon','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','39YC59','2015','4','A-145',396,0,'Paris','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RL75','2015','3','A-134',67,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RL75','2015','5','B-245',304,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RL75','2015','6','B-287',56,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RS75','2015','4','A-150',255,0,'Montreuil','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RS75','2015','5','B-258',341,0,'Montreuil','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','42RS75','2015','6','B-300',163,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','71PO37','2015','4','C-58',189,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','71PO37','2015','6','B-273',189,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','87AZ92','2015','4','C-61',345,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C668','87AZ92','2015','6','B-276',345,0,'Paris','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','11RS75','2015','4','A-154',363,0,'Neuilly','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','11TR62','2015','4','A-140',421,0,'Montreuil','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','11UI62','2015','3','A-129',204,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','11UI62','2015','6','B-307',283,0,'Montreuil','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','23AA46','2015','4','A-157',270,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','23AA46','2015','5','B-253',272,0,'Paris','Montreuil',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','23AA46','2015','6','B-295',440,0,'Montreuil','Paris',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','23TR62','2015','4','A-143',360,0,'Neuilly','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','32RS75','2015','3','A-132',115,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','32RS75','2015','5','B-243',366,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','32RS75','2015','6','B-285',166,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','39YC59','2015','5','B-256',155,0,'Neuilly','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','39YC59','2015','6','B-298',450,0,'Nantes','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','42RL75','2015','4','A-146',87,0,'Montreuil','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','42RS75','2015','3','A-135',224,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','42RS75','2015','5','B-246',164,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','42RS75','2015','6','B-288',238,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','56ER46','2015','4','A-151',165,0,'Neuilly','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','56ER46','2015','5','B-259',121,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','56ER46','2015','6','B-301',209,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','71RT37','2015','4','C-59',546,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','71RT37','2015','6','B-274',546,0,'Nantes','Nantes',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','90AA46','2015','4','C-62',234,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C669','90AA46','2015','6','B-277',234,0,'Lyon','Lyon',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','56AA46','2015','4','D-45',437,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','90AA46','2015','4','D-46',47,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','71RT37','2015','4','D-47',43,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','56ER46','2015','4','D-48',76,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','71PO37','2015','4','D-49',61,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','87AZ92','2015','4','D-50',58,0,'Paris','Neuilly',0000-00,0000-00);
INSERT INTO `loueur`.`location` (`codeC`,`immat`,`annee`,`mois`,`numLoc`,`km`,`duree`,`villeD`,`villeA`,`dateD`,`dateF`) VALUES ('C667','42RS75','2015','4','D-51',189,0,'Paris','Neuilly',0000-00,0000-00);
--
select 'client', count(*) from  client ;
select 'proprietaire' , count(*) from  proprietaire ;
select 'voiture' , count(*) from  voiture ;
select 'location' , count(*) from  location ;