PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "pulls" (
"id" INTEGER,
  "couleur" TEXT,
  "taille" TEXT,
  "stock" INTEGER,
  "prix" INTEGER
);
INSERT INTO pulls VALUES(1,'rouge','S',11,34);
INSERT INTO pulls VALUES(2,'rouge','M',7,34);
INSERT INTO pulls VALUES(3,'rouge','L',45,34);
INSERT INTO pulls VALUES(4,'rouge','XL',37,34);
INSERT INTO pulls VALUES(5,'vert','S',45,32);
INSERT INTO pulls VALUES(6,'vert','M',34,32);
INSERT INTO pulls VALUES(7,'vert','L',47,32);
INSERT INTO pulls VALUES(8,'vert','XL',28,32);
INSERT INTO pulls VALUES(9,'bleu','S',34,29);
INSERT INTO pulls VALUES(10,'bleu','M',42,29);
INSERT INTO pulls VALUES(11,'bleu','L',47,29);
INSERT INTO pulls VALUES(12,'bleu','XL',47,29);
INSERT INTO pulls VALUES(13,'noir','S',27,29);
INSERT INTO pulls VALUES(14,'noir','M',37,29);
INSERT INTO pulls VALUES(15,'noir','L',37,29);
INSERT INTO pulls VALUES(16,'noir','XL',30,29);
INSERT INTO pulls VALUES(17,'blanc','S',14,30);
INSERT INTO pulls VALUES(18,'blanc','M',20,30);
INSERT INTO pulls VALUES(19,'blanc','L',27,30);
INSERT INTO pulls VALUES(20,'blanc','XL',34,30);
INSERT INTO pulls VALUES(21,'gris','S',36,34);
INSERT INTO pulls VALUES(22,'gris','M',33,34);
INSERT INTO pulls VALUES(23,'gris','L',37,34);
INSERT INTO pulls VALUES(24,'gris','XL',36,34);
INSERT INTO pulls VALUES(25,'rose','S',39,33);
INSERT INTO pulls VALUES(26,'rose','M',14,33);
INSERT INTO pulls VALUES(27,'rose','L',49,33);
INSERT INTO pulls VALUES(28,'rose','XL',24,33);
INSERT INTO pulls VALUES(29,'marron','S',24,29);
INSERT INTO pulls VALUES(30,'marron','M',31,29);
INSERT INTO pulls VALUES(31,'marron','L',21,29);
INSERT INTO pulls VALUES(32,'marron','XL',28,29);
INSERT INTO pulls VALUES(33,'jaune','S',49,28);
INSERT INTO pulls VALUES(34,'jaune','M',33,28);
INSERT INTO pulls VALUES(35,'jaune','L',42,28);
INSERT INTO pulls VALUES(36,'jaune','XL',25,28);
INSERT INTO pulls VALUES(37,'violet','S',18,31);
INSERT INTO pulls VALUES(38,'violet','M',31,31);
INSERT INTO pulls VALUES(39,'violet','L',9,31);
INSERT INTO pulls VALUES(40,'violet','XL',30,31);
CREATE TABLE IF NOT EXISTS "clients" (
"id" INTEGER,
  "nom" TEXT,
  "email" TEXT,
  "adresse" TEXT
);
INSERT INTO clients VALUES(1,'Joseph Martin','j.martin@gmail.com','129 avenue Pythagore, Rouen');
INSERT INTO clients VALUES(2,'Joseph Bernard','j.bernard@gmail.com','68 boulevard Carl Gauss, Mulhouse');
INSERT INTO clients VALUES(3,'Joseph Thomas','j.thomas@gmail.com','19 rue Euclide, Lyon');
INSERT INTO clients VALUES(4,'Auguste Petit','a.petit@gmail.com','17 rue Pythagore, Nîmes');
INSERT INTO clients VALUES(5,'Mathis Robert','m.robert@gmail.com','100 rue Thalès, Orléans');
INSERT INTO clients VALUES(6,'Antoine Richard','a.richard@gmail.com','31 rue Evariste Galois, Toulouse');
INSERT INTO clients VALUES(7,'Adrien Durand','a.durand@gmail.com','39 boulevard Pythagore, Tours');
INSERT INTO clients VALUES(8,'Gabriel Dubois','g.dubois@gmail.com','197 rue Pythagore, Nîmes');
INSERT INTO clients VALUES(9,'Antoine Moreau','a.moreau@gmail.com','198 avenue du lac, Caen');
INSERT INTO clients VALUES(10,'Martin Laurent','m.laurent@gmail.com','59 avenue Thalès, Paris');
INSERT INTO clients VALUES(11,'Adrien Simon','a.simon@gmail.com','6 avenue des fleurs, Reims');
INSERT INTO clients VALUES(12,'Léo Michel','l.michel@gmail.com','123 boulevard Euclide, Perpignan');
INSERT INTO clients VALUES(13,'Samuel Lefebvre','s.lefebvre@gmail.com','139 rue Isaac Newton, Montreuil');
INSERT INTO clients VALUES(14,'Augustin Leroy','a.leroy@gmail.com','169 boulevard des fleurs, Reims');
INSERT INTO clients VALUES(15,'Oscar Roux','o.roux@gmail.com','141 rue Euclide, Nanterre');
INSERT INTO clients VALUES(16,'Camille David','c.david@gmail.com','126 avenue Evariste Galois, Besançon');
INSERT INTO clients VALUES(17,'Gabriel Bertrand','g.bertrand@gmail.com','1 avenue du lac, Saint-Étienne');
INSERT INTO clients VALUES(18,'Marceau Morel','m.morel@gmail.com','152 rue Carl Gauss, Toulon');
INSERT INTO clients VALUES(19,'Clément Fournier','c.fournier@gmail.com','122 boulevard Carl Gauss, Nantes');
INSERT INTO clients VALUES(20,'Gaspard Girard','g.girard@gmail.com','4 rue des fleurs, Bordeaux');
INSERT INTO clients VALUES(21,'Côme Bonnet','c.bonnet@gmail.com','33 rue Pythagore, Roubaix');
INSERT INTO clients VALUES(22,'Roméo Dupont','r.dupont@gmail.com','193 avenue Evariste Galois, Nîmes');
INSERT INTO clients VALUES(23,'Roméo Lambert','r.lambert@gmail.com','108 boulevard des fleurs, Bordeaux');
INSERT INTO clients VALUES(24,'Augustin Fontaine','a.fontaine@gmail.com','3 rue Thalès, Bordeaux');
INSERT INTO clients VALUES(25,'Simon Rousseau','s.rousseau@gmail.com','11 avenue Euclide, Lille');
INSERT INTO clients VALUES(26,'Maxime Vincent','m.vincent@gmail.com','178 avenue Evariste Galois, Perpignan');
INSERT INTO clients VALUES(27,'Abel Muller','a.muller@gmail.com','69 avenue des fleurs, Strasbourg');
INSERT INTO clients VALUES(28,'Alexis Lefevre','a.lefevre@gmail.com','117 rue des fleurs, Rennes');
INSERT INTO clients VALUES(29,'Axel Faure','a.faure@gmail.com','136 avenue Pythagore, Paris');
INSERT INTO clients VALUES(30,'Basile Andre','b.andre@gmail.com','108 rue du lac, Saint-Paul');
INSERT INTO clients VALUES(31,'Gabin Mercier','g.mercier@gmail.com','133 boulevard Pythagore, Argenteuil');
INSERT INTO clients VALUES(32,'Marin Blanc','m.blanc@gmail.com','145 boulevard Thalès, Strasbourg');
INSERT INTO clients VALUES(33,'Jean Guerin','j.guerin@gmail.com','123 rue Pythagore, Lille');
INSERT INTO clients VALUES(34,'Gaspard Boyer','g.boyer@gmail.com','194 rue Carl Gauss, Nice');
INSERT INTO clients VALUES(35,'Nathan Garnier','n.garnier@gmail.com','94 rue Pythagore, Strasbourg');
INSERT INTO clients VALUES(36,'Abel Chevalier','a.chevalier@gmail.com','9 avenue Pythagore, Argenteuil');
INSERT INTO clients VALUES(37,'Augustin Francois','a.francois@gmail.com','128 rue Carl Gauss, Grenoble');
INSERT INTO clients VALUES(38,'Maxence Legrand','m.legrand@gmail.com','96 boulevard des fleurs, Bordeaux');
INSERT INTO clients VALUES(39,'Léo Gauthier','l.gauthier@gmail.com','45 rue Evariste Galois, Nantes');
INSERT INTO clients VALUES(40,'Marceau Garcia','m.garcia@gmail.com','3 boulevard Pythagore, Saint-Denis');
INSERT INTO clients VALUES(41,'Roméo Perrin','r.perrin@gmail.com','155 rue du lac, Roubaix');
INSERT INTO clients VALUES(42,'Augustin Robin','a.robin@gmail.com','73 boulevard Isaac Newton, Toulouse');
INSERT INTO clients VALUES(43,'Victor Clement','v.clement@gmail.com','166 rue Thalès, Metz');
INSERT INTO clients VALUES(44,'Léon Morin','l.morin@gmail.com','140 rue Thalès, Le Havre');
INSERT INTO clients VALUES(45,'Joseph Nicolas','j.nicolas@gmail.com','122 avenue Pythagore, Toulon');
INSERT INTO clients VALUES(46,'Gaspard Henry','g.henry@gmail.com','39 avenue Evariste Galois, Nîmes');
INSERT INTO clients VALUES(47,'William Roussel','w.roussel@gmail.com','76 rue Carl Gauss, Boulogne-Billancourt');
INSERT INTO clients VALUES(48,'Antoine Mathieu','a.mathieu@gmail.com','104 boulevard du lac, Nancy');
INSERT INTO clients VALUES(49,'Joseph Gautier','j.gautier@gmail.com','117 boulevard Isaac Newton, Bordeaux');
INSERT INTO clients VALUES(50,'Clément Masson','c.masson@gmail.com','47 rue des fleurs, Aubervilliers');
INSERT INTO clients VALUES(51,'Axel Marchand','a.marchand@gmail.com','53 rue Euclide, Nanterre');
INSERT INTO clients VALUES(52,'Léon Duval','l.duval@gmail.com','98 avenue Euclide, Amiens');
INSERT INTO clients VALUES(53,'Antoine Denis','a.denis@gmail.com','55 boulevard Carl Gauss, Aix-en-Provence');
INSERT INTO clients VALUES(54,'Raphaël Dumont','r.dumont@gmail.com','50 avenue Pythagore, Poitiers');
INSERT INTO clients VALUES(55,'Gabin Marie','g.marie@gmail.com','24 rue Isaac Newton, Saint-Étienne');
INSERT INTO clients VALUES(56,'Gabin Lemaire','g.lemaire@gmail.com','17 rue Pythagore, Paris');
INSERT INTO clients VALUES(57,'Nathan Noel','n.noel@gmail.com','61 rue Carl Gauss, Toulon');
INSERT INTO clients VALUES(58,'Léo Meyer','l.meyer@gmail.com','151 avenue Evariste Galois, Argenteuil');
INSERT INTO clients VALUES(59,'Thomas Dufour','t.dufour@gmail.com','137 rue Thalès, Saint-Denis');
INSERT INTO clients VALUES(60,'Victor Meunier','v.meunier@gmail.com','93 avenue des fleurs, Besançon');
INSERT INTO clients VALUES(61,'Mathis Brun','m.brun@gmail.com','144 avenue Carl Gauss, Saint-Denis');
INSERT INTO clients VALUES(62,'Léon Blanchard','l.blanchard@gmail.com','152 rue Carl Gauss, Lyon');
INSERT INTO clients VALUES(63,'Gaspard Giraud','g.giraud@gmail.com','57 rue du lac, Roubaix');
INSERT INTO clients VALUES(64,'Hugo Joly','h.joly@gmail.com','5 rue Evariste Galois, Nantes');
INSERT INTO clients VALUES(65,'Malo Riviere','m.riviere@gmail.com','85 boulevard Evariste Galois, Tours');
INSERT INTO clients VALUES(66,'Hugo Lucas','h.lucas@gmail.com','94 rue Evariste Galois, Metz');
INSERT INTO clients VALUES(67,'Maxime Brunet','m.brunet@gmail.com','94 rue Pythagore, Metz');
INSERT INTO clients VALUES(68,'Maxime Gaillard','m.gaillard@gmail.com','147 rue Evariste Galois, Metz');
INSERT INTO clients VALUES(69,'William Barbier','w.barbier@gmail.com','98 boulevard Euclide, Montpellier');
INSERT INTO clients VALUES(70,'Baptiste Arnaud','b.arnaud@gmail.com','169 avenue Evariste Galois, Annecy');
INSERT INTO clients VALUES(71,'Mathys Martinez','m.martinez@gmail.com','63 rue du lac, Aubervilliers');
INSERT INTO clients VALUES(72,'Adam Gerard','a.gerard@gmail.com','53 rue du lac, Strasbourg');
INSERT INTO clients VALUES(73,'Gabriel Roche','g.roche@gmail.com','85 avenue Thalès, Saint-Paul');
INSERT INTO clients VALUES(74,'Paul Renard','p.renard@gmail.com','165 rue Evariste Galois, Avignon');
INSERT INTO clients VALUES(75,'Jean Schmitt','j.schmitt@gmail.com','108 rue Pythagore, Grenoble');
INSERT INTO clients VALUES(76,'Maxence Roy','m.roy@gmail.com','87 rue du lac, Villeurbanne');
INSERT INTO clients VALUES(77,'Marceau Leroux','m.leroux@gmail.com','39 avenue Isaac Newton, Nancy');
INSERT INTO clients VALUES(78,'Camille Colin','c.colin@gmail.com','8 boulevard Thalès, Saint-Paul');
INSERT INTO clients VALUES(79,'Marceau Vidal','m.vidal@gmail.com','88 rue Pythagore, Aubervilliers');
INSERT INTO clients VALUES(80,'Gabriel Caron','g.caron@gmail.com','105 avenue Thalès, Paris');
INSERT INTO clients VALUES(81,'William Picard','w.picard@gmail.com','103 rue des fleurs, Aix-en-Provence');
INSERT INTO clients VALUES(82,'Samuel Roger','s.roger@gmail.com','61 rue des fleurs, Vitry-sur-Seine');
INSERT INTO clients VALUES(83,'Roméo Fabre','r.fabre@gmail.com','101 rue des fleurs, Marseille');
INSERT INTO clients VALUES(84,'Malo Aubert','m.aubert@gmail.com','106 boulevard Pythagore, Nice');
INSERT INTO clients VALUES(85,'Marius Lemoine','m.lemoine@gmail.com','26 avenue du lac, Bordeaux');
INSERT INTO clients VALUES(86,'Paul Renaud','p.renaud@gmail.com','7 rue du lac, Rouen');
INSERT INTO clients VALUES(87,'Nathan Dumas','n.dumas@gmail.com','43 boulevard Carl Gauss, Grenoble');
INSERT INTO clients VALUES(88,'Jules Lacroix','j.lacroix@gmail.com','129 boulevard Euclide, Poitiers');
INSERT INTO clients VALUES(89,'Antoine Olivier','a.olivier@gmail.com','21 rue Isaac Newton, Toulouse');
INSERT INTO clients VALUES(90,'Malo Philippe','m.philippe@gmail.com','59 avenue Evariste Galois, Amiens');
INSERT INTO clients VALUES(91,'Hugo Bourgeois','h.bourgeois@gmail.com','44 avenue du lac, Amiens');
INSERT INTO clients VALUES(92,'Roméo Pierre','r.pierre@gmail.com','190 rue Thalès, Caen');
INSERT INTO clients VALUES(93,'Marius Benoit','m.benoit@gmail.com','79 rue Isaac Newton, Rennes');
INSERT INTO clients VALUES(94,'Marin Rey','m.rey@gmail.com','10 rue Carl Gauss, Argenteuil');
INSERT INTO clients VALUES(95,'Adrien Leclerc','a.leclerc@gmail.com','100 boulevard Isaac Newton, Montreuil');
INSERT INTO clients VALUES(96,'Alexandre Payet','a.payet@gmail.com','67 avenue Pythagore, Lyon');
INSERT INTO clients VALUES(97,'Alexis Rolland','a.rolland@gmail.com','110 avenue Isaac Newton, Grenoble');
INSERT INTO clients VALUES(98,'Alexis Leclercq','a.leclercq@gmail.com','132 avenue Thalès, Montreuil');
INSERT INTO clients VALUES(99,'Malo Guillaume','m.guillaume@gmail.com','192 rue Evariste Galois, Brest');
INSERT INTO clients VALUES(100,'Baptiste Lecomte','b.lecomte@gmail.com','198 avenue Evariste Galois, Limoges');
INSERT INTO clients VALUES(101,'Marceau Lopez','m.lopez@gmail.com','17 rue du lac, Argenteuil');
INSERT INTO clients VALUES(102,'Augustin Jean','a.jean@gmail.com','182 rue Carl Gauss, Clermont-Ferrand');
INSERT INTO clients VALUES(103,'Samuel Dupuy','s.dupuy@gmail.com','110 rue Thalès, Aix-en-Provence');
INSERT INTO clients VALUES(104,'Maxime Guillot','m.guillot@gmail.com','189 rue Thalès, Rennes');
INSERT INTO clients VALUES(105,'Arthur Hubert','a.hubert@gmail.com','68 rue Evariste Galois, Avignon');
INSERT INTO clients VALUES(106,'Adam Berger','a.berger@gmail.com','80 rue des fleurs, Vitry-sur-Seine');
INSERT INTO clients VALUES(107,'Camille Carpentier','c.carpentier@gmail.com','81 avenue du lac, Saint-Étienne');
INSERT INTO clients VALUES(108,'Joseph Sanchez','j.sanchez@gmail.com','82 boulevard des fleurs, Toulouse');
INSERT INTO clients VALUES(109,'Baptiste Dupuis','b.dupuis@gmail.com','17 avenue Euclide, Lyon');
INSERT INTO clients VALUES(110,'Oscar Moulin','o.moulin@gmail.com','13 avenue Evariste Galois, Vitry-sur-Seine');
INSERT INTO clients VALUES(111,'Marin Louis','m.louis@gmail.com','39 rue Pythagore, Bordeaux');
INSERT INTO clients VALUES(112,'Mathys Deschamps','m.deschamps@gmail.com','162 boulevard Thalès, Tours');
INSERT INTO clients VALUES(113,'Malo Huet','m.huet@gmail.com','179 rue Thalès, Boulogne-Billancourt');
INSERT INTO clients VALUES(114,'Valentin Vasseur','v.vasseur@gmail.com','173 avenue Isaac Newton, Metz');
INSERT INTO clients VALUES(115,'Camille Perez','c.perez@gmail.com','90 avenue Thalès, Strasbourg');
INSERT INTO clients VALUES(116,'Oscar Boucher','o.boucher@gmail.com','177 boulevard des fleurs, Perpignan');
INSERT INTO clients VALUES(117,'Oscar Fleury','o.fleury@gmail.com','149 avenue Euclide, Nîmes');
INSERT INTO clients VALUES(118,'Marin Royer','m.royer@gmail.com','142 boulevard Carl Gauss, Rennes');
INSERT INTO clients VALUES(119,'Jules Klein','j.klein@gmail.com','106 rue Evariste Galois, Boulogne-Billancourt');
INSERT INTO clients VALUES(120,'Léandre Jacquet','l.jacquet@gmail.com','68 avenue Isaac Newton, Caen');
INSERT INTO clients VALUES(121,'Thomas Adam','t.adam@gmail.com','12 rue Carl Gauss, Aix-en-Provence');
INSERT INTO clients VALUES(122,'Gabin Paris','g.paris@gmail.com','145 rue Pythagore, Marseille');
INSERT INTO clients VALUES(123,'Clément Poirier','c.poirier@gmail.com','118 rue Pythagore, Metz');
INSERT INTO clients VALUES(124,'Simon Marty','s.marty@gmail.com','53 rue Carl Gauss, Roubaix');
INSERT INTO clients VALUES(125,'Martin Aubry','m.aubry@gmail.com','155 rue des fleurs, Lille');
INSERT INTO clients VALUES(126,'Augustin Guyot','a.guyot@gmail.com','111 rue des fleurs, Le Havre');
INSERT INTO clients VALUES(127,'Roméo Carre','r.carre@gmail.com','179 boulevard des fleurs, Poitiers');
INSERT INTO clients VALUES(128,'William Charles','w.charles@gmail.com','74 rue Evariste Galois, Paris');
INSERT INTO clients VALUES(129,'Hugo Renault','h.renault@gmail.com','39 rue Evariste Galois, Strasbourg');
INSERT INTO clients VALUES(130,'Roméo Charpentier','r.charpentier@gmail.com','167 rue des fleurs, Toulon');
INSERT INTO clients VALUES(131,'Maxime Menard','m.menard@gmail.com','142 rue Evariste Galois, Besançon');
INSERT INTO clients VALUES(132,'Léo Maillard','l.maillard@gmail.com','119 rue du lac, Limoges');
INSERT INTO clients VALUES(133,'Alexis Baron','a.baron@gmail.com','116 rue Carl Gauss, Nanterre');
INSERT INTO clients VALUES(134,'William Bertin','w.bertin@gmail.com','13 avenue Carl Gauss, Saint-Paul');
INSERT INTO clients VALUES(135,'Auguste Bailly','a.bailly@gmail.com','14 rue Thalès, Rennes');
INSERT INTO clients VALUES(136,'Roméo Herve','r.herve@gmail.com','55 rue du lac, Tours');
INSERT INTO clients VALUES(137,'Léon Schneider','l.schneider@gmail.com','106 boulevard Evariste Galois, Tours');
INSERT INTO clients VALUES(138,'Adrien Fernandez','a.fernandez@gmail.com','39 rue des fleurs, Dijon');
INSERT INTO clients VALUES(139,'Malo Le','m.le@gmail.com','115 rue du lac, Poitiers');
INSERT INTO clients VALUES(140,'Maxence Collet','m.collet@gmail.com','61 rue des fleurs, Le Mans');
INSERT INTO clients VALUES(141,'Oscar Leger','o.leger@gmail.com','179 rue Pythagore, Montreuil');
INSERT INTO clients VALUES(142,'Gaspard Bouvier','g.bouvier@gmail.com','2 rue Euclide, Saint-Paul');
INSERT INTO clients VALUES(143,'Camille Julien','c.julien@gmail.com','192 boulevard Evariste Galois, Nîmes');
INSERT INTO clients VALUES(144,'Hugo Prevost','h.prevost@gmail.com','11 rue Carl Gauss, Nantes');
INSERT INTO clients VALUES(145,'Joseph Millet','j.millet@gmail.com','176 boulevard Thalès, Villeurbanne');
INSERT INTO clients VALUES(146,'Auguste Perrot','a.perrot@gmail.com','61 rue Isaac Newton, Marseille');
INSERT INTO clients VALUES(147,'Lucas Daniel','l.daniel@gmail.com','91 avenue du lac, Annecy');
INSERT INTO clients VALUES(148,'Valentin Le','v.le@gmail.com','126 rue Carl Gauss, Bordeaux');
INSERT INTO clients VALUES(149,'Arthur Cousin','a.cousin@gmail.com','50 rue Pythagore, Nantes');
INSERT INTO clients VALUES(150,'Baptiste Germain','b.germain@gmail.com','161 avenue Thalès, Caen');
INSERT INTO clients VALUES(151,'Martin Breton','m.breton@gmail.com','157 boulevard Isaac Newton, Amiens');
INSERT INTO clients VALUES(152,'Maxence Besson','m.besson@gmail.com','177 rue des fleurs, Villeurbanne');
INSERT INTO clients VALUES(153,'Maxence Langlois','m.langlois@gmail.com','127 rue Thalès, Mulhouse');
INSERT INTO clients VALUES(154,'Auguste Remy','a.remy@gmail.com','106 avenue Evariste Galois, Nantes');
INSERT INTO clients VALUES(155,'Léon Le','l.le@gmail.com','129 boulevard des fleurs, Strasbourg');
INSERT INTO clients VALUES(156,'Augustin Pelletier','a.pelletier@gmail.com','30 rue Evariste Galois, Lille');
INSERT INTO clients VALUES(157,'David Leveque','d.leveque@gmail.com','51 rue Euclide, Saint-Denis');
INSERT INTO clients VALUES(158,'Samuel Perrier','s.perrier@gmail.com','152 boulevard Carl Gauss, Grenoble');
INSERT INTO clients VALUES(159,'Adam Leblanc','a.leblanc@gmail.com','24 avenue des fleurs, Marseille');
INSERT INTO clients VALUES(160,'Mathys Barre','m.barre@gmail.com','180 boulevard Pythagore, Tours');
INSERT INTO clients VALUES(161,'Marceau Lebrun','m.lebrun@gmail.com','173 rue Thalès, Montpellier');
INSERT INTO clients VALUES(162,'Axel Marchal','a.marchal@gmail.com','39 rue du lac, Lille');
INSERT INTO clients VALUES(163,'Léon Weber','l.weber@gmail.com','116 avenue Pythagore, Saint-Étienne');
INSERT INTO clients VALUES(164,'Maxence Mallet','m.mallet@gmail.com','143 avenue Pythagore, Saint-Paul');
INSERT INTO clients VALUES(165,'Arthur Hamon','a.hamon@gmail.com','183 avenue Evariste Galois, Poitiers');
INSERT INTO clients VALUES(166,'Jean Boulanger','j.boulanger@gmail.com','104 rue du lac, Bordeaux');
INSERT INTO clients VALUES(167,'Valentin Jacob','v.jacob@gmail.com','101 rue des fleurs, Nice');
INSERT INTO clients VALUES(168,'Lucas Monnier','l.monnier@gmail.com','44 rue Carl Gauss, Saint-Paul');
INSERT INTO clients VALUES(169,'Marin Michaud','m.michaud@gmail.com','169 avenue Pythagore, Brest');
INSERT INTO clients VALUES(170,'William Rodriguez','w.rodriguez@gmail.com','155 boulevard Evariste Galois, Lyon');
INSERT INTO clients VALUES(171,'Marius Guichard','m.guichard@gmail.com','117 avenue Pythagore, Aix-en-Provence');
INSERT INTO clients VALUES(172,'Marin Gillet','m.gillet@gmail.com','129 avenue Euclide, Tourcoing');
INSERT INTO clients VALUES(173,'Alexis Etienne','a.etienne@gmail.com','158 avenue Euclide, Aubervilliers');
INSERT INTO clients VALUES(174,'Clément Grondin','c.grondin@gmail.com','42 avenue des fleurs, Aix-en-Provence');
INSERT INTO clients VALUES(175,'Simon Poulain','s.poulain@gmail.com','38 rue Thalès, Saint-Paul');
INSERT INTO clients VALUES(176,'Paul Tessier','p.tessier@gmail.com','112 rue Evariste Galois, Lille');
INSERT INTO clients VALUES(177,'Roméo Chevallier','r.chevallier@gmail.com','105 avenue Thalès, Aubervilliers');
INSERT INTO clients VALUES(178,'Auguste Collin','a.collin@gmail.com','23 avenue Isaac Newton, Dijon');
INSERT INTO clients VALUES(179,'Marius Chauvin','m.chauvin@gmail.com','144 boulevard Thalès, Montpellier');
INSERT INTO clients VALUES(180,'Baptiste Da','b.da@gmail.com','12 avenue Isaac Newton, Metz');
INSERT INTO clients VALUES(181,'Basile Bouchet','b.bouchet@gmail.com','93 boulevard Carl Gauss, Le Mans');
INSERT INTO clients VALUES(182,'Roméo Gay','r.gay@gmail.com','114 rue Euclide, Nice');
INSERT INTO clients VALUES(183,'Lucas Lemaitre','l.lemaitre@gmail.com','114 boulevard Isaac Newton, Le Havre');
INSERT INTO clients VALUES(184,'Léandre Benard','l.benard@gmail.com','156 rue Thalès, Mulhouse');
INSERT INTO clients VALUES(185,'Alexandre Marechal','a.marechal@gmail.com','88 rue Pythagore, Créteil');
INSERT INTO clients VALUES(186,'Hugo Humbert','h.humbert@gmail.com','129 rue des fleurs, Marseille');
INSERT INTO clients VALUES(187,'Thomas Reynaud','t.reynaud@gmail.com','10 avenue Thalès, Nîmes');
INSERT INTO clients VALUES(188,'Clément Antoine','c.antoine@gmail.com','45 rue Isaac Newton, Toulouse');
INSERT INTO clients VALUES(189,'Oscar Hoarau','o.hoarau@gmail.com','41 rue Isaac Newton, Saint-Paul');
INSERT INTO clients VALUES(190,'Léo Perret','l.perret@gmail.com','125 boulevard Evariste Galois, Boulogne-Billancourt');
INSERT INTO clients VALUES(191,'Malo Barthelemy','m.barthelemy@gmail.com','76 rue Euclide, Avignon');
INSERT INTO clients VALUES(192,'Mathys Cordier','m.cordier@gmail.com','172 avenue Thalès, Caen');
INSERT INTO clients VALUES(193,'Maxime Pichon','m.pichon@gmail.com','101 rue Isaac Newton, Avignon');
INSERT INTO clients VALUES(194,'Marin Lejeune','m.lejeune@gmail.com','30 rue du lac, Bordeaux');
INSERT INTO clients VALUES(195,'William Gilbert','w.gilbert@gmail.com','154 rue du lac, Saint-Étienne');
INSERT INTO clients VALUES(196,'Roméo Lamy','r.lamy@gmail.com','129 rue Carl Gauss, Boulogne-Billancourt');
INSERT INTO clients VALUES(197,'Camille Delaunay','c.delaunay@gmail.com','1 rue des fleurs, Tourcoing');
INSERT INTO clients VALUES(198,'Léo Pasquier','l.pasquier@gmail.com','148 boulevard Pythagore, Nanterre');
INSERT INTO clients VALUES(199,'Adam Carlier','a.carlier@gmail.com','170 boulevard Pythagore, Lille');
INSERT INTO clients VALUES(200,'David Laporte','d.laporte@gmail.com','98 rue des fleurs, Limoges');
CREATE TABLE IF NOT EXISTS "ventes" (
"id" INTEGER,
  "num_commande" INTEGER,
  "id_client" INTEGER,
  "id_pull" INTEGER,
  "quantite" INTEGER
);
INSERT INTO ventes VALUES(1,1,198,23,2);
INSERT INTO ventes VALUES(2,1,198,27,1);
INSERT INTO ventes VALUES(3,2,102,15,1);
INSERT INTO ventes VALUES(4,2,102,22,1);
INSERT INTO ventes VALUES(5,3,23,33,1);
INSERT INTO ventes VALUES(6,4,62,20,1);
INSERT INTO ventes VALUES(7,4,62,11,1);
INSERT INTO ventes VALUES(8,5,78,23,2);
INSERT INTO ventes VALUES(9,6,94,29,2);
INSERT INTO ventes VALUES(10,7,173,36,2);
INSERT INTO ventes VALUES(11,8,169,19,2);
INSERT INTO ventes VALUES(12,9,34,35,1);
INSERT INTO ventes VALUES(13,10,121,8,2);
INSERT INTO ventes VALUES(14,10,121,22,1);
INSERT INTO ventes VALUES(15,11,39,31,1);
INSERT INTO ventes VALUES(16,11,39,38,2);
INSERT INTO ventes VALUES(17,12,77,21,2);
INSERT INTO ventes VALUES(18,12,77,36,2);
INSERT INTO ventes VALUES(19,13,57,31,1);
INSERT INTO ventes VALUES(20,13,57,30,2);
INSERT INTO ventes VALUES(21,14,166,30,1);
INSERT INTO ventes VALUES(22,15,67,11,1);
INSERT INTO ventes VALUES(23,16,169,23,1);
INSERT INTO ventes VALUES(24,16,169,34,2);
INSERT INTO ventes VALUES(25,17,121,30,1);
INSERT INTO ventes VALUES(26,17,121,40,2);
INSERT INTO ventes VALUES(27,18,146,13,1);
INSERT INTO ventes VALUES(28,18,146,39,2);
INSERT INTO ventes VALUES(29,19,130,13,2);
INSERT INTO ventes VALUES(30,20,17,5,2);
INSERT INTO ventes VALUES(31,21,100,12,2);
INSERT INTO ventes VALUES(32,21,100,13,1);
INSERT INTO ventes VALUES(33,22,61,36,2);
INSERT INTO ventes VALUES(34,23,54,23,1);
INSERT INTO ventes VALUES(35,23,54,26,2);
INSERT INTO ventes VALUES(36,24,111,6,1);
INSERT INTO ventes VALUES(37,24,111,10,1);
INSERT INTO ventes VALUES(38,25,30,12,2);
INSERT INTO ventes VALUES(39,26,171,5,1);
INSERT INTO ventes VALUES(40,26,171,8,1);
INSERT INTO ventes VALUES(41,27,150,8,1);
INSERT INTO ventes VALUES(42,28,184,33,1);
INSERT INTO ventes VALUES(43,28,184,7,2);
INSERT INTO ventes VALUES(44,29,67,26,1);
INSERT INTO ventes VALUES(45,30,96,17,1);
INSERT INTO ventes VALUES(46,30,96,33,2);
INSERT INTO ventes VALUES(47,31,171,12,2);
INSERT INTO ventes VALUES(48,32,178,39,2);
INSERT INTO ventes VALUES(49,32,178,26,1);
INSERT INTO ventes VALUES(50,33,53,36,2);
INSERT INTO ventes VALUES(51,34,166,5,1);
INSERT INTO ventes VALUES(52,34,166,33,1);
INSERT INTO ventes VALUES(53,35,169,12,2);
INSERT INTO ventes VALUES(54,36,3,2,1);
INSERT INTO ventes VALUES(55,37,100,38,2);
INSERT INTO ventes VALUES(56,37,100,31,2);
INSERT INTO ventes VALUES(57,38,169,2,1);
INSERT INTO ventes VALUES(58,38,169,15,2);
INSERT INTO ventes VALUES(59,39,199,21,2);
INSERT INTO ventes VALUES(60,39,199,16,1);
INSERT INTO ventes VALUES(61,40,21,36,1);
INSERT INTO ventes VALUES(62,40,21,33,1);
INSERT INTO ventes VALUES(63,41,62,24,2);
INSERT INTO ventes VALUES(64,41,62,25,1);
INSERT INTO ventes VALUES(65,42,161,16,1);
INSERT INTO ventes VALUES(66,42,161,2,2);
INSERT INTO ventes VALUES(67,43,129,8,1);
INSERT INTO ventes VALUES(68,43,129,38,1);
INSERT INTO ventes VALUES(69,44,190,13,2);
INSERT INTO ventes VALUES(70,45,175,11,1);
INSERT INTO ventes VALUES(71,45,175,3,2);
INSERT INTO ventes VALUES(72,46,78,24,1);
INSERT INTO ventes VALUES(73,46,78,18,2);
INSERT INTO ventes VALUES(74,47,41,9,1);
INSERT INTO ventes VALUES(75,47,41,27,2);
INSERT INTO ventes VALUES(76,48,70,27,1);
INSERT INTO ventes VALUES(77,49,58,39,1);
INSERT INTO ventes VALUES(78,50,176,23,1);
INSERT INTO ventes VALUES(79,50,176,35,1);
INSERT INTO ventes VALUES(80,51,24,19,1);
INSERT INTO ventes VALUES(81,52,78,29,2);
INSERT INTO ventes VALUES(82,53,27,20,1);
INSERT INTO ventes VALUES(83,53,27,1,2);
INSERT INTO ventes VALUES(84,54,109,16,1);
INSERT INTO ventes VALUES(85,55,47,11,1);
INSERT INTO ventes VALUES(86,56,128,14,1);
INSERT INTO ventes VALUES(87,56,128,7,1);
INSERT INTO ventes VALUES(88,57,49,18,1);
INSERT INTO ventes VALUES(89,57,49,14,2);
INSERT INTO ventes VALUES(90,58,13,11,2);
INSERT INTO ventes VALUES(91,59,8,24,1);
INSERT INTO ventes VALUES(92,60,144,34,2);
INSERT INTO ventes VALUES(93,61,174,13,1);
INSERT INTO ventes VALUES(94,61,174,22,2);
INSERT INTO ventes VALUES(95,62,191,28,1);
INSERT INTO ventes VALUES(96,63,186,23,2);
INSERT INTO ventes VALUES(97,63,186,14,2);
INSERT INTO ventes VALUES(98,64,91,33,2);
INSERT INTO ventes VALUES(99,64,91,40,2);
INSERT INTO ventes VALUES(100,65,74,26,1);
INSERT INTO ventes VALUES(101,65,74,27,2);
INSERT INTO ventes VALUES(102,66,165,4,2);
INSERT INTO ventes VALUES(103,66,165,37,2);
INSERT INTO ventes VALUES(104,67,15,2,2);
INSERT INTO ventes VALUES(105,67,15,37,2);
INSERT INTO ventes VALUES(106,68,163,39,1);
INSERT INTO ventes VALUES(107,68,163,3,1);
INSERT INTO ventes VALUES(108,69,165,23,1);
INSERT INTO ventes VALUES(109,69,165,35,1);
INSERT INTO ventes VALUES(110,70,117,38,2);
INSERT INTO ventes VALUES(111,70,117,18,1);
INSERT INTO ventes VALUES(112,71,43,2,2);
INSERT INTO ventes VALUES(113,72,80,18,2);
INSERT INTO ventes VALUES(114,72,80,24,2);
INSERT INTO ventes VALUES(115,73,155,18,1);
INSERT INTO ventes VALUES(116,74,55,12,1);
INSERT INTO ventes VALUES(117,74,55,18,1);
INSERT INTO ventes VALUES(118,75,175,11,1);
INSERT INTO ventes VALUES(119,76,9,32,1);
INSERT INTO ventes VALUES(120,76,9,17,1);
INSERT INTO ventes VALUES(121,77,139,28,1);
INSERT INTO ventes VALUES(122,78,65,38,1);
INSERT INTO ventes VALUES(123,78,65,16,2);
INSERT INTO ventes VALUES(124,79,106,26,2);
INSERT INTO ventes VALUES(125,79,106,5,2);
INSERT INTO ventes VALUES(126,80,129,1,2);
INSERT INTO ventes VALUES(127,80,129,18,1);
INSERT INTO ventes VALUES(128,81,135,6,1);
INSERT INTO ventes VALUES(129,81,135,32,2);
INSERT INTO ventes VALUES(130,82,66,24,2);
INSERT INTO ventes VALUES(131,82,66,5,2);
INSERT INTO ventes VALUES(132,83,166,1,2);
INSERT INTO ventes VALUES(133,84,157,18,1);
INSERT INTO ventes VALUES(134,84,157,38,2);
INSERT INTO ventes VALUES(135,85,20,32,2);
INSERT INTO ventes VALUES(136,85,20,10,1);
INSERT INTO ventes VALUES(137,86,93,32,2);
INSERT INTO ventes VALUES(138,86,93,6,1);
INSERT INTO ventes VALUES(139,87,21,9,1);
INSERT INTO ventes VALUES(140,88,29,19,2);
INSERT INTO ventes VALUES(141,89,87,15,2);
INSERT INTO ventes VALUES(142,90,127,39,1);
INSERT INTO ventes VALUES(143,90,127,31,2);
INSERT INTO ventes VALUES(144,91,169,20,2);
INSERT INTO ventes VALUES(145,92,154,8,1);
INSERT INTO ventes VALUES(146,93,156,11,1);
INSERT INTO ventes VALUES(147,94,103,16,1);
INSERT INTO ventes VALUES(148,95,113,14,2);
INSERT INTO ventes VALUES(149,95,113,12,2);
INSERT INTO ventes VALUES(150,96,140,16,1);
INSERT INTO ventes VALUES(151,97,62,39,2);
INSERT INTO ventes VALUES(152,98,102,4,1);
INSERT INTO ventes VALUES(153,99,165,8,2);
INSERT INTO ventes VALUES(154,99,165,37,1);
COMMIT;