SQLite Forum

Need some help
Login

Need some help

(1) By NotSpecialist on 2021-11-29 11:58:40 [link] [source]

Question : "Give the total of the invoice no_command '10248'. Note, we can obtain the product of two attributes with: *"

(FR)Client = Customer/Produit = Product no_commande = Order number (of the command), societe/code_postal/pays/categorie not needed ref_produit = product reference/quantite =quantity (really useful I guess) PRIX_UNITAIRE = Unit Price NOM_PRODUIT = PRODUCT_NAME (Copy paste) ------->

If you need informations, tell me.

BEGIN TRANSACTION;

CREATE TABLE IF NOT EXISTS "CLIENTS"( "CODE_CLIENT" CHAR(5) NOT NULL, "SOCIETE" TEXT NOT NULL, "ADRESSE" TEXT NOT NULL, "VILLE" TEXT NOT NULL, "CODE_POSTAL" TEXT NOT NULL, "PAYS" TEXT NOT NULL, "CATEGORIE" TEXT NOT NULL);

CREATE TABLE IF NOT EXISTS "COMMANDES" (
"NO_COMMANDE"	INT NOT NULL,
"DATE_COMMANDE"	 TEXT NOT NULL,
"CODE_CLIENT"	TEXT NOT NULL

); CREATE TABLE IF NOT EXISTS "DETAILS_COMMANDES" ( "NO_COMMANDE" INT NOT NULL, "REF_PRODUIT" TEXT NOT NULL, "QUANTITE" INT NOT NULL DEFAULT '1'

); CREATE TABLE IF NOT EXISTS "PRODUITS" ( "REF_PRODUIT" TEXT NOT NULL, "NOM_PRODUIT" TEXT NOT NULL, "PRIX_UNITAIRE" INT NOT NULL );

INSERT INTO "CLIENTS" VALUES ('ALFKI','Alfreds Futterkiste','Obere Str. 57','Berlin','12209','Allemagne',2); INSERT INTO "CLIENTS" VALUES ('AROUT','Around the Horn','120 Hanover Sq.','London','WA1 1DP','Royaume-Uni',2); INSERT INTO "CLIENTS" VALUES ('BLAUS','Blauer See Delikatessen','Forsterstr. 57','Mannheim','68306','Allemagne',2); INSERT INTO "CLIENTS" VALUES ('BONAP','Bon app''','12, rue des Bouchers','Marseille','13008','France',2); INSERT INTO "CLIENTS" VALUES ('BOTTM','Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','T2F 8M4','Canada',2); INSERT INTO "CLIENTS" VALUES ('BSBEV','B''s Beverages','Fauntleroy Circus','London','EC2 5NT','Royaume-Uni',3); INSERT INTO "CLIENTS" VALUES ('CACTU','Cactus Comidas para llevar','Cerrito 333','Buenos Aires','1010','Argentine',2); INSERT INTO "CLIENTS" VALUES ('CHOPS','Chop-suey Chinese','Hauptstr. 29','Bern','3012','Suisse',0); INSERT INTO "CLIENTS" VALUES ('CONSH','Consolidated Holdings','Berkeley Gardens12 Brewery ','London','WX1 6LT','Royaume-Uni',3); INSERT INTO "CLIENTS" VALUES ('DRACD','Drachenblut Delikatessen','Walserweg 21','Aachen','52066','Allemagne',2); INSERT INTO "CLIENTS" VALUES ('DUMON','Du monde entier','67, rue des Cinquante Otages','Nantes','44000','France',2); INSERT INTO "CLIENTS" VALUES ('EASTC','Eastern Connection','35 King George','London','WX3 6FW','Royaume-Uni',2); INSERT INTO "CLIENTS" VALUES ('ERNSH','Ernst Handel','Kirchgasse 6','Graz','8010','Autriche',1); INSERT INTO "CLIENTS" VALUES ('FISSA','FISSA Fabrica Inter. Salchichas S.A.','Moralzarzal, 86','Madrid','28034','Espagne',1); INSERT INTO "CLIENTS" VALUES ('FRANR','France restauration','54, rue Royale','Nantes','44000','France',3); INSERT INTO "CLIENTS" VALUES ('FRANS','Franchi S.p.A.','Via Monte Bianco 34','Torino','10100','Italie',1); INSERT INTO "CLIENTS" VALUES ('FURIB','Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa','1675','Portugal',1); INSERT INTO "CLIENTS" VALUES ('GODOS','Godos Cocina Tipica','Romero, 33','Sevilla','41101','Espagne',3); INSERT INTO "CLIENTS" VALUES ('HUNGO','Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','2506','Irlande',3); INSERT INTO "CLIENTS" VALUES ('ISLAT','Island Trading','Garden HouseCrowther Way','Cowes','PO31 7PJ','Royaume-Uni',2); INSERT INTO "CLIENTS" VALUES ('LACOR','La corne d''abondance','67, avenue de l''Europe','Versailles','78000','France',2); INSERT INTO "CLIENTS" VALUES ('LAMAI','La maison d''Asie','1 rue Alsace-Lorraine','Toulouse','31000','France',2); INSERT INTO "CLIENTS" VALUES ('LAUGB','Laughing Bacchus Wine Cellars','1900 Oak St.','Vancouver','V3F 2K1','Canada',2); INSERT INTO "CLIENTS" VALUES ('LEHMS','Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ','60528','Allemagne',1); INSERT INTO "CLIENTS" VALUES ('MAGAA','Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo','24100','Italie',1); INSERT INTO "CLIENTS" VALUES ('MAISD','Maison Dewey','Rue Joseph-Bens 532','Bruxelles','B-1180','Belgique',0); INSERT INTO "CLIENTS" VALUES ('MORGK','Morgenstern Gesundkost','Heerstr. 22','Leipzig','04179','Allemagne',0); INSERT INTO "CLIENTS" VALUES ('NORTS','North/South','South House300 Queensbridge','London','SW7 1RZ','Royaume-Uni',1); INSERT INTO "CLIENTS" VALUES ('PICCO','Piccolo und mehr','Geislweg 14','Salzburg','5020','Autriche',2); INSERT INTO "CLIENTS" VALUES ('RANCH','Rancho grande','Av. del Libertador 900','Buenos Aires','1010','Argentine',2); INSERT INTO "CLIENTS" VALUES ('REGGC','Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia','42100','Italie',1); INSERT INTO "CLIENTS" VALUES ('SEVES','Seven Seas Imports','90 Wadhurst Rd.','London','OX15 4NB','Royaume-Uni',3); INSERT INTO "CLIENTS" VALUES ('VICTE','Victuailles en stock','2, rue du Commerce','Lyon','69004','France',2); INSERT INTO "CLIENTS" VALUES ('VINET','Vins et alcools Chevalier','59 rue de l''Abbaye','Reims','51100','France',1); INSERT INTO "CLIENTS" VALUES ('WANDK','Die Wandernde Kuh','Adenauerallee 900','Stuttgart','70563','Allemagne',3); INSERT INTO "CLIENTS" VALUES ('WARTH','Wartian Herkku','Torikatu 38','Oulu','90110','Finlande',2); INSERT INTO "CLIENTS" VALUES ('WILMK','Wilman Kala','Keskuskatu 45','Helsinki','21240','Finlande',3); INSERT INTO "CLIENTS" VALUES ('WOLZA','Wolski Zajazd','ul. Filtrowa 68','Warszawa','01-012','Pologne',1); INSERT INTO "COMMANDES" VALUES (10248,'2008-02-04','VINET'); INSERT INTO "COMMANDES" VALUES (10251,'2008-09-08','VICTE'); INSERT INTO "COMMANDES" VALUES (10254,'2008-05-11','CHOPS'); INSERT INTO "COMMANDES" VALUES (10258,'2008-07-17','ERNSH'); INSERT INTO "COMMANDES" VALUES (10263,'2008-03-23','ERNSH'); INSERT INTO "COMMANDES" VALUES (10266,'2008-11-26','WARTH'); INSERT INTO "COMMANDES" VALUES (10270,'2008-12-01','WARTH'); INSERT INTO "COMMANDES" VALUES (10274,'2008-12-06','VINET'); INSERT INTO "COMMANDES" VALUES (10275,'2008-10-07','MAGAA'); INSERT INTO "COMMANDES" VALUES (10277,'2008-10-09','MORGK'); INSERT INTO "COMMANDES" VALUES (10279,'2008-04-13','LEHMS'); INSERT INTO "COMMANDES" VALUES (10284,'2008-02-19','LEHMS'); INSERT INTO "COMMANDES" VALUES (10288,'2008-07-23','REGGC'); INSERT INTO "COMMANDES" VALUES (10289,'2008-02-26','BSBEV'); INSERT INTO "COMMANDES" VALUES (10295,'2008-01-02','VINET'); INSERT INTO "COMMANDES" VALUES (10298,'2008-08-05','HUNGO'); INSERT INTO "COMMANDES" VALUES (10300,'2008-10-09','MAGAA'); INSERT INTO "COMMANDES" VALUES (10301,'2008-03-09','WANDK'); INSERT INTO "COMMANDES" VALUES (10303,'2008-02-11','GODOS'); INSERT INTO "COMMANDES" VALUES (10309,'2008-12-19','HUNGO'); INSERT INTO "COMMANDES" VALUES (10311,'2008-10-20','DUMON'); INSERT INTO "COMMANDES" VALUES (10312,'2008-07-23','WANDK'); INSERT INTO "COMMANDES" VALUES (10315,'2008-03-26','ISLAT'); INSERT INTO "COMMANDES" VALUES (10318,'2008-08-01','ISLAT'); INSERT INTO "COMMANDES" VALUES (10320,'2008-02-03','WARTH'); INSERT INTO "COMMANDES" VALUES (10321,'2008-07-03','ISLAT'); INSERT INTO "COMMANDES" VALUES (10328,'2008-11-14','FURIB'); INSERT INTO "COMMANDES" VALUES (10331,'2008-04-16','BONAP'); INSERT INTO "COMMANDES" VALUES (10333,'2008-07-18','WARTH'); INSERT INTO "COMMANDES" VALUES (10334,'2008-05-21','VICTE'); INSERT INTO "COMMANDES" VALUES (10335,'2008-07-22','HUNGO'); INSERT INTO "COMMANDES" VALUES (10340,'2008-12-29','BONAP'); INSERT INTO "COMMANDES" VALUES (10343,'2008-01-31','LEHMS'); INSERT INTO "COMMANDES" VALUES (10348,'2008-03-07','WANDK'); INSERT INTO "COMMANDES" VALUES (10350,'2008-12-11','LAMAI'); INSERT INTO "COMMANDES" VALUES (10351,'2008-12-11','ERNSH'); INSERT INTO "COMMANDES" VALUES (10352,'2008-12-12','FURIB'); INSERT INTO "COMMANDES" VALUES (10353,'2008-12-13','PICCO'); INSERT INTO "COMMANDES" VALUES (10355,'2008-03-15','AROUT'); INSERT INTO "COMMANDES" VALUES (10356,'2008-09-18','WANDK'); INSERT INTO "COMMANDES" VALUES (10358,'2008-08-20','LAMAI'); INSERT INTO "COMMANDES" VALUES (10359,'2008-07-21','SEVES'); INSERT INTO "COMMANDES" VALUES (10362,'2008-05-25','BONAP'); INSERT INTO "COMMANDES" VALUES (10363,'2008-05-26','DRACD'); INSERT INTO "COMMANDES" VALUES (10364,'2008-03-26','EASTC'); INSERT INTO "COMMANDES" VALUES (10368,'2008-10-29','ERNSH'); INSERT INTO "COMMANDES" VALUES (10370,'2008-02-03','CHOPS'); INSERT INTO "COMMANDES" VALUES (10371,'2008-09-03','LAMAI'); INSERT INTO "COMMANDES" VALUES (10373,'2008-06-05','HUNGO'); INSERT INTO "COMMANDES" VALUES (10374,'2008-08-05','WOLZA'); INSERT INTO "COMMANDES" VALUES (10377,'2008-08-09','SEVES'); INSERT INTO "COMMANDES" VALUES (10380,'2008-03-12','HUNGO'); INSERT INTO "COMMANDES" VALUES (10382,'2008-08-13','ERNSH'); INSERT INTO "COMMANDES" VALUES (10383,'2008-03-16','AROUT'); INSERT INTO "COMMANDES" VALUES (10388,'2008-12-19','SEVES'); INSERT INTO "COMMANDES" VALUES (10389,'2008-08-20','BOTTM'); INSERT INTO "COMMANDES" VALUES (10390,'2008-12-23','ERNSH'); INSERT INTO "COMMANDES" VALUES (10391,'2008-08-23','DRACD'); INSERT INTO "COMMANDES" VALUES (10392,'2008-03-24','PICCO'); INSERT INTO "COMMANDES" VALUES (10400,'2009-10-01','EASTC'); INSERT INTO "COMMANDES" VALUES (10402,'2009-05-02','ERNSH'); INSERT INTO "COMMANDES" VALUES (10403,'2009-01-03','ERNSH'); INSERT INTO "COMMANDES" VALUES (10404,'2009-11-03','MAGAA'); INSERT INTO "COMMANDES" VALUES (10410,'2009-03-10','BOTTM'); INSERT INTO "COMMANDES" VALUES (10411,'2009-03-10','BOTTM'); INSERT INTO "COMMANDES" VALUES (10412,'2009-10-13','WARTH'); INSERT INTO "COMMANDES" VALUES (10413,'2009-10-14','LAMAI'); INSERT INTO "COMMANDES" VALUES (10416,'2009-06-16','WARTH'); INSERT INTO "COMMANDES" VALUES (10422,'2009-02-22','FRANS'); INSERT INTO "COMMANDES" VALUES (10425,'2009-06-24','LAMAI'); INSERT INTO "COMMANDES" VALUES (10427,'2009-10-27','PICCO'); INSERT INTO "COMMANDES" VALUES (10428,'2009-08-28','REGGC'); INSERT INTO "COMMANDES" VALUES (10429,'2009-10-29','HUNGO'); INSERT INTO "COMMANDES" VALUES (10430,'0000-00-00','ERNSH'); INSERT INTO "COMMANDES" VALUES (10431,'2009-10-30','BOTTM'); INSERT INTO "COMMANDES" VALUES (10435,'2009-09-04','CONSH'); INSERT INTO "COMMANDES" VALUES (10437,'2009-03-05','WARTH'); INSERT INTO "COMMANDES" VALUES (10442,'2009-03-11','ERNSH'); INSERT INTO "COMMANDES" VALUES (10443,'2009-08-12','REGGC'); INSERT INTO "COMMANDES" VALUES (10448,'2009-08-17','RANCH'); INSERT INTO "COMMANDES" VALUES (10450,'2009-10-19','VICTE'); INSERT INTO "COMMANDES" VALUES (10453,'2009-07-21','AROUT'); INSERT INTO "COMMANDES" VALUES (10454,'2009-09-21','LAMAI'); INSERT INTO "COMMANDES" VALUES (10455,'2009-12-24','WARTH'); INSERT INTO "COMMANDES" VALUES (10459,'2009-07-27','VICTE'); INSERT INTO "COMMANDES" VALUES (10462,'2009-12-03','CONSH'); INSERT INTO "COMMANDES" VALUES (10464,'2009-07-04','FURIB'); INSERT INTO "COMMANDES" VALUES (10467,'2009-07-06','MAGAA'); INSERT INTO "COMMANDES" VALUES (10470,'2009-01-11','BONAP'); INSERT INTO "COMMANDES" VALUES (10471,'2009-12-11','BSBEV'); INSERT INTO "COMMANDES" VALUES (10472,'2009-05-12','SEVES'); INSERT INTO "COMMANDES" VALUES (10473,'2009-12-13','ISLAT'); INSERT INTO "COMMANDES" VALUES (10478,'2009-08-18','VICTE'); INSERT INTO "COMMANDES" VALUES (10484,'2009-04-24','BSBEV'); INSERT INTO "COMMANDES" VALUES (10489,'2009-03-28','PICCO'); INSERT INTO "COMMANDES" VALUES (10491,'2009-05-31','FURIB'); INSERT INTO "COMMANDES" VALUES (10492,'2009-01-01','BOTTM'); INSERT INTO "COMMANDES" VALUES (10493,'2009-04-02','LAMAI'); INSERT INTO "COMMANDES" VALUES (10495,'2009-03-03','LAUGB'); INSERT INTO "COMMANDES" VALUES (10497,'2009-04-04','LEHMS'); INSERT INTO "COMMANDES" VALUES (10500,'2009-12-09','LAMAI'); INSERT INTO "COMMANDES" VALUES (10501,'2009-06-09','BLAUS'); INSERT INTO "COMMANDES" VALUES (10503,'2009-06-11','HUNGO'); INSERT INTO "COMMANDES" VALUES (10509,'2009-02-17','BLAUS'); INSERT INTO "COMMANDES" VALUES (10511,'2009-09-18','BONAP'); INSERT INTO "COMMANDES" VALUES (10513,'2009-03-22','WANDK'); INSERT INTO "COMMANDES" VALUES (10514,'2009-05-22','ERNSH'); INSERT INTO "COMMANDES" VALUES (10516,'2009-08-24','HUNGO'); INSERT INTO "COMMANDES" VALUES (10517,'2009-07-24','NORTS'); INSERT INTO "COMMANDES" VALUES (10519,'2009-04-28','CHOPS'); INSERT INTO "COMMANDES" VALUES (10521,'2009-10-29','CACTU'); INSERT INTO "COMMANDES" VALUES (10522,'2009-08-30','LEHMS'); INSERT INTO "COMMANDES" VALUES (10523,'2009-03-01','SEVES'); INSERT INTO "COMMANDES" VALUES (10525,'2009-10-02','BONAP'); INSERT INTO "COMMANDES" VALUES (10526,'2009-04-05','WARTH'); INSERT INTO "COMMANDES" VALUES (10529,'2009-07-07','MAISD'); INSERT INTO "COMMANDES" VALUES (10530,'2009-10-08','PICCO'); INSERT INTO "COMMANDES" VALUES (10532,'2009-03-09','EASTC'); INSERT INTO "COMMANDES" VALUES (10534,'2009-09-12','LEHMS'); INSERT INTO "COMMANDES" VALUES (10536,'2009-09-14','LEHMS'); INSERT INTO "COMMANDES" VALUES (10538,'2009-03-15','BSBEV'); INSERT INTO "COMMANDES" VALUES (10539,'2009-12-16','BSBEV'); INSERT INTO "COMMANDES" VALUES (10546,'2009-05-23','VICTE'); INSERT INTO "COMMANDES" VALUES (10547,'2009-05-23','SEVES'); INSERT INTO "COMMANDES" VALUES (10550,'2009-08-28','GODOS'); INSERT INTO "COMMANDES" VALUES (10551,'2009-02-28','FURIB'); INSERT INTO "COMMANDES" VALUES (10553,'2009-11-30','WARTH'); INSERT INTO "COMMANDES" VALUES (10557,'2009-11-03','LEHMS'); INSERT INTO "COMMANDES" VALUES (10558,'2009-09-04','AROUT'); INSERT INTO "COMMANDES" VALUES (10562,'2009-09-09','REGGC'); INSERT INTO "COMMANDES" VALUES (10567,'2009-11-12','HUNGO'); INSERT INTO "COMMANDES" VALUES (10571,'2009-11-17','ERNSH'); INSERT INTO "COMMANDES" VALUES (10575,'2009-11-20','MORGK'); INSERT INTO "COMMANDES" VALUES (10578,'2009-03-24','BSBEV'); INSERT INTO "COMMANDES" VALUES (10582,'2009-12-27','BLAUS'); INSERT INTO "COMMANDES" VALUES (10583,'2009-08-30','WARTH'); INSERT INTO "COMMANDES" VALUES (10586,'2009-03-02','REGGC'); INSERT INTO "COMMANDES" VALUES (10592,'2009-01-08','LEHMS'); INSERT INTO "COMMANDES" VALUES (10593,'2009-02-09','LEHMS'); INSERT INTO "COMMANDES" VALUES (10595,'2009-07-10','ERNSH'); INSERT INTO "COMMANDES" VALUES (10597,'2009-06-11','PICCO'); INSERT INTO "COMMANDES" VALUES (10599,'2009-03-15','BSBEV'); INSERT INTO "COMMANDES" VALUES (10604,'2009-06-18','FURIB'); INSERT INTO "COMMANDES" VALUES (10609,'2009-11-24','DUMON'); INSERT INTO "COMMANDES" VALUES (10610,'2009-01-25','LAMAI'); INSERT INTO "COMMANDES" VALUES (10611,'2009-08-25','WOLZA'); INSERT INTO "COMMANDES" VALUES (10614,'2009-10-29','BLAUS'); INSERT INTO "COMMANDES" VALUES (10615,'2009-04-30','WILMK'); INSERT INTO "COMMANDES" VALUES (10620,'2009-07-05','LAUGB'); INSERT INTO "COMMANDES" VALUES (10621,'2009-01-05','ISLAT'); INSERT INTO "COMMANDES" VALUES (10629,'2009-10-12','GODOS'); INSERT INTO "COMMANDES" VALUES (10631,'2009-06-14','LAMAI'); INSERT INTO "COMMANDES" VALUES (10632,'2009-10-14','WANDK'); INSERT INTO "COMMANDES" VALUES (10633,'2009-10-15','ERNSH'); INSERT INTO "COMMANDES" VALUES (10635,'2009-04-18','MAGAA'); INSERT INTO "COMMANDES" VALUES (10636,'2009-06-19','WARTH'); INSERT INTO "COMMANDES" VALUES (10640,'2009-04-21','WANDK'); INSERT INTO "COMMANDES" VALUES (10643,'2009-03-25','AROUT'); INSERT INTO "COMMANDES" VALUES (10646,'2009-12-27','HUNGO'); INSERT INTO "COMMANDES" VALUES (10649,'2009-02-28','MAISD'); INSERT INTO "COMMANDES" VALUES (10651,'2009-05-01','WANDK'); INSERT INTO "COMMANDES" VALUES (10655,'2009-08-03','REGGC'); INSERT INTO "COMMANDES" VALUES (10661,'2009-06-09','HUNGO'); INSERT INTO "COMMANDES" VALUES (10663,'2009-11-10','BONAP'); INSERT INTO "COMMANDES" VALUES (10664,'2009-10-10','FURIB'); INSERT INTO "COMMANDES" VALUES (10667,'2009-03-12','ERNSH'); INSERT INTO "COMMANDES" VALUES (10668,'2009-08-15','WANDK'); INSERT INTO "COMMANDES" VALUES (10671,'2009-06-17','FRANR'); INSERT INTO "COMMANDES" VALUES (10673,'2009-05-18','WILMK'); INSERT INTO "COMMANDES" VALUES (10674,'2009-05-18','ISLAT'); INSERT INTO "COMMANDES" VALUES (10683,'2009-03-26','DUMON'); INSERT INTO "COMMANDES" VALUES (10686,'2009-12-30','PICCO'); INSERT INTO "COMMANDES" VALUES (10687,'2009-07-30','HUNGO'); INSERT INTO "COMMANDES" VALUES (10692,'2009-04-03','BSBEV'); INSERT INTO "COMMANDES" VALUES (10695,'2009-03-07','WILMK'); INSERT INTO "COMMANDES" VALUES (10698,'2009-08-09','ERNSH'); INSERT INTO "COMMANDES" VALUES (10699,'2009-09-09','MORGK'); INSERT INTO "COMMANDES" VALUES (10701,'2009-09-13','HUNGO'); INSERT INTO "COMMANDES" VALUES (10702,'2009-11-13','ALFKI'); INSERT INTO "COMMANDES" VALUES (10707,'2009-03-16','AROUT'); INSERT INTO "COMMANDES" VALUES (10710,'2009-01-20','FRANS'); INSERT INTO "COMMANDES" VALUES (10712,'2009-06-21','HUNGO'); INSERT INTO "COMMANDES" VALUES (10715,'2009-04-23','BONAP'); INSERT INTO "COMMANDES" VALUES (10716,'2009-10-24','RANCH'); INSERT INTO "COMMANDES" VALUES (10726,'2009-01-03','EASTC'); INSERT INTO "COMMANDES" VALUES (10727,'2009-10-03','REGGC'); INSERT INTO "COMMANDES" VALUES (10730,'2009-05-05','BONAP'); INSERT INTO "COMMANDES" VALUES (10731,'2009-03-06','CHOPS'); INSERT INTO "COMMANDES" VALUES (10732,'2009-12-06','BONAP'); INSERT INTO "COMMANDES" VALUES (10736,'2009-07-11','HUNGO'); INSERT INTO "COMMANDES" VALUES (10737,'2009-06-11','VINET'); INSERT INTO "COMMANDES" VALUES (10739,'2009-08-12','VINET'); INSERT INTO "COMMANDES" VALUES (10741,'2009-09-14','AROUT'); INSERT INTO "COMMANDES" VALUES (10742,'2009-07-14','BOTTM'); INSERT INTO "COMMANDES" VALUES (10743,'2009-02-17','AROUT'); INSERT INTO "COMMANDES" VALUES (10746,'2009-01-19','CHOPS'); INSERT INTO "COMMANDES" VALUES (10747,'2009-04-19','PICCO'); INSERT INTO "COMMANDES" VALUES (10749,'2009-07-20','ISLAT'); INSERT INTO "COMMANDES" VALUES (10750,'2009-08-21','WARTH'); INSERT INTO "COMMANDES" VALUES (10752,'2009-09-24','NORTS'); INSERT INTO "COMMANDES" VALUES (10753,'2009-02-25','FRANS'); INSERT INTO "COMMANDES" VALUES (10754,'2009-04-25','MAGAA'); INSERT INTO "COMMANDES" VALUES (10755,'2009-02-26','BONAP'); INSERT INTO "COMMANDES" VALUES (10760,'2009-05-01','MAISD'); INSERT INTO "COMMANDES" VALUES (10764,'2009-04-03','ERNSH'); INSERT INTO "COMMANDES" VALUES (10768,'2009-05-08','AROUT'); INSERT INTO "COMMANDES" VALUES (10771,'2009-04-10','ERNSH'); INSERT INTO "COMMANDES" VALUES (10772,'2009-07-10','LEHMS'); INSERT INTO "COMMANDES" VALUES (10773,'2009-03-11','ERNSH'); INSERT INTO "COMMANDES" VALUES (10776,'2009-12-15','ERNSH'); INSERT INTO "COMMANDES" VALUES (10779,'2009-01-16','MORGK'); INSERT INTO "COMMANDES" VALUES (10781,'2009-09-17','WARTH'); INSERT INTO "COMMANDES" VALUES (10782,'2009-12-17','CACTU'); INSERT INTO "COMMANDES" VALUES (10784,'2009-11-18','MAGAA'); INSERT INTO "COMMANDES" VALUES (10787,'2009-02-19','LAMAI'); INSERT INTO "COMMANDES" VALUES (10792,'2009-08-23','WOLZA'); INSERT INTO "COMMANDES" VALUES (10793,'2009-05-24','AROUT'); INSERT INTO "COMMANDES" VALUES (10795,'2009-10-24','ERNSH'); INSERT INTO "COMMANDES" VALUES (10797,'2009-04-25','DRACD'); INSERT INTO "COMMANDES" VALUES (10798,'2009-10-26','ISLAT'); INSERT INTO "COMMANDES" VALUES (10800,'2009-12-26','SEVES'); INSERT INTO "COMMANDES" VALUES (10804,'2009-10-30','SEVES'); INSERT INTO "COMMANDES" VALUES (10806,'2009-12-31','VICTE'); INSERT INTO "COMMANDES" VALUES (10807,'2009-05-31','FRANS'); INSERT INTO "COMMANDES" VALUES (10810,'2010-06-01','LAUGB'); INSERT INTO "COMMANDES" VALUES (10812,'2010-05-02','REGGC'); INSERT INTO "COMMANDES" VALUES (10814,'2010-11-05','VICTE'); INSERT INTO "COMMANDES" VALUES (10818,'2010-09-07','MAGAA'); INSERT INTO "COMMANDES" VALUES (10819,'2010-10-07','CACTU'); INSERT INTO "COMMANDES" VALUES (10825,'2010-05-09','DRACD'); INSERT INTO "COMMANDES" VALUES (10827,'2010-03-12','BONAP'); INSERT INTO "COMMANDES" VALUES (10828,'2010-08-13','RANCH'); INSERT INTO "COMMANDES" VALUES (10829,'2010-08-13','ISLAT'); INSERT INTO "COMMANDES" VALUES (10832,'2010-12-14','LAMAI'); INSERT INTO "COMMANDES" VALUES (10835,'2010-03-15','ALFKI'); INSERT INTO "COMMANDES" VALUES (10836,'2010-11-16','ERNSH'); INSERT INTO "COMMANDES" VALUES (10843,'2010-01-21','VICTE'); INSERT INTO "COMMANDES" VALUES (10844,'2010-03-21','PICCO'); INSERT INTO "COMMANDES" VALUES (10848,'2010-12-23','CONSH'); INSERT INTO "COMMANDES" VALUES (10850,'2010-08-23','VICTE'); INSERT INTO "COMMANDES" VALUES (10853,'2010-12-27','BLAUS'); INSERT INTO "COMMANDES" VALUES (10854,'2010-10-27','ERNSH'); INSERT INTO "COMMANDES" VALUES (10858,'2010-06-29','LACOR'); INSERT INTO "COMMANDES" VALUES (10860,'2010-03-29','FRANR'); INSERT INTO "COMMANDES" VALUES (10862,'2010-01-30','LEHMS'); INSERT INTO "COMMANDES" VALUES (10864,'2010-05-02','AROUT'); INSERT INTO "COMMANDES" VALUES (10869,'2010-08-04','SEVES'); INSERT INTO "COMMANDES" VALUES (10870,'2010-04-04','WOLZA'); INSERT INTO "COMMANDES" VALUES (10871,'2010-06-05','BONAP'); INSERT INTO "COMMANDES" VALUES (10872,'2010-08-05','GODOS'); INSERT INTO "COMMANDES" VALUES (10873,'2010-12-06','WILMK'); INSERT INTO "COMMANDES" VALUES (10874,'2010-09-06','GODOS'); INSERT INTO "COMMANDES" VALUES (10876,'2010-11-09','BONAP'); INSERT INTO "COMMANDES" VALUES (10879,'2010-10-10','WILMK'); INSERT INTO "COMMANDES" VALUES (10881,'2010-07-11','CACTU'); INSERT INTO "COMMANDES" VALUES (10888,'2010-10-16','GODOS'); INSERT INTO "COMMANDES" VALUES (10890,'2010-12-16','DUMON'); INSERT INTO "COMMANDES" VALUES (10891,'2010-07-17','LEHMS'); INSERT INTO "COMMANDES" VALUES (10892,'2010-03-17','MAISD'); INSERT INTO "COMMANDES" VALUES (10895,'2010-06-18','ERNSH'); INSERT INTO "COMMANDES" VALUES (10896,'2010-10-19','MAISD'); INSERT INTO "COMMANDES" VALUES (10897,'2010-10-19','HUNGO'); INSERT INTO "COMMANDES" VALUES (10906,'2010-09-25','WOLZA'); INSERT INTO "COMMANDES" VALUES (10908,'2010-08-26','REGGC'); INSERT INTO "COMMANDES" VALUES (10910,'2010-10-26','WILMK'); INSERT INTO "COMMANDES" VALUES (10911,'2010-04-26','GODOS'); INSERT INTO "COMMANDES" VALUES (10912,'2010-05-26','HUNGO'); INSERT INTO "COMMANDES" VALUES (10916,'2010-11-27','RANCH'); INSERT INTO "COMMANDES" VALUES (10918,'2010-10-02','BOTTM'); INSERT INTO "COMMANDES" VALUES (10920,'2010-10-03','AROUT'); INSERT INTO "COMMANDES" VALUES (10923,'2010-03-03','LAMAI'); INSERT INTO "COMMANDES" VALUES (10927,'2010-11-05','LACOR'); INSERT INTO "COMMANDES" VALUES (10932,'2010-06-06','BONAP'); INSERT INTO "COMMANDES" VALUES (10933,'2010-05-06','ISLAT'); INSERT INTO "COMMANDES" VALUES (10934,'2010-10-09','LEHMS'); INSERT INTO "COMMANDES" VALUES (10937,'2010-11-10','CACTU'); INSERT INTO "COMMANDES" VALUES (10939,'2010-02-10','MAGAA'); INSERT INTO "COMMANDES" VALUES (10940,'2010-06-11','BONAP'); INSERT INTO "COMMANDES" VALUES (10942,'2010-04-11','REGGC'); INSERT INTO "COMMANDES" VALUES (10943,'2010-07-11','BSBEV'); INSERT INTO "COMMANDES" VALUES (10944,'2010-04-12','BOTTM'); INSERT INTO "COMMANDES" VALUES (10945,'2010-05-12','MORGK'); INSERT INTO "COMMANDES" VALUES (10947,'2010-09-13','BSBEV'); INSERT INTO "COMMANDES" VALUES (10948,'2010-11-13','GODOS'); INSERT INTO "COMMANDES" VALUES (10949,'2010-02-13','BOTTM'); INSERT INTO "COMMANDES" VALUES (10950,'2010-09-16','MAGAA'); INSERT INTO "COMMANDES" VALUES (10952,'2010-06-16','ALFKI'); INSERT INTO "COMMANDES" VALUES (10953,'2010-01-16','AROUT'); INSERT INTO "COMMANDES" VALUES (10956,'2010-11-17','BLAUS'); INSERT INTO "COMMANDES" VALUES (10963,'2010-03-19','FURIB'); INSERT INTO "COMMANDES" VALUES (10966,'2010-09-20','CHOPS'); INSERT INTO "COMMANDES" VALUES (10968,'2010-03-23','ERNSH'); INSERT INTO "COMMANDES" VALUES (10971,'2010-08-24','FRANR'); INSERT INTO "COMMANDES" VALUES (10972,'2010-03-24','LACOR'); INSERT INTO "COMMANDES" VALUES (10973,'2010-11-24','LACOR'); INSERT INTO "COMMANDES" VALUES (10975,'2010-10-25','BOTTM'); INSERT INTO "COMMANDES" VALUES (10978,'2010-12-26','MAISD'); INSERT INTO "COMMANDES" VALUES (10979,'2010-12-26','ERNSH'); INSERT INTO "COMMANDES" VALUES (10982,'2010-04-27','BOTTM'); INSERT INTO "COMMANDES" VALUES (10985,'2010-04-30','HUNGO'); INSERT INTO "COMMANDES" VALUES (10987,'2010-08-31','EASTC'); INSERT INTO "COMMANDES" VALUES (10990,'2010-08-01','ERNSH'); INSERT INTO "COMMANDES" VALUES (10998,'2010-10-03','WOLZA'); INSERT INTO "COMMANDES" VALUES (11004,'2010-09-07','MAISD'); INSERT INTO "COMMANDES" VALUES (11005,'2010-04-07','WILMK'); INSERT INTO "COMMANDES" VALUES (11008,'2010-11-08','ERNSH'); INSERT INTO "COMMANDES" VALUES (11009,'2010-09-08','GODOS'); INSERT INTO "COMMANDES" VALUES (11010,'2010-04-09','REGGC'); INSERT INTO "COMMANDES" VALUES (11011,'2010-05-09','ALFKI'); INSERT INTO "COMMANDES" VALUES (11016,'2010-02-10','AROUT'); INSERT INTO "COMMANDES" VALUES (11017,'2010-06-13','ERNSH'); INSERT INTO "COMMANDES" VALUES (11019,'2010-02-13','RANCH'); INSERT INTO "COMMANDES" VALUES (11023,'2010-03-14','BSBEV'); INSERT INTO "COMMANDES" VALUES (11024,'2010-07-15','EASTC'); INSERT INTO "COMMANDES" VALUES (11025,'2010-02-15','WARTH'); INSERT INTO "COMMANDES" VALUES (11026,'2010-08-15','FRANS'); INSERT INTO "COMMANDES" VALUES (11027,'2010-01-16','BOTTM'); INSERT INTO "COMMANDES" VALUES (11029,'2010-11-16','CHOPS'); INSERT INTO "COMMANDES" VALUES (11036,'2010-03-20','DRACD'); INSERT INTO "COMMANDES" VALUES (11037,'2010-05-21','GODOS'); INSERT INTO "COMMANDES" VALUES (11041,'2010-12-22','CHOPS'); INSERT INTO "COMMANDES" VALUES (11044,'2010-03-23','WOLZA'); INSERT INTO "COMMANDES" VALUES (11045,'2010-09-23','BOTTM'); INSERT INTO "COMMANDES" VALUES (11046,'2010-04-23','WANDK'); INSERT INTO "COMMANDES" VALUES (11047,'2010-12-24','EASTC'); INSERT INTO "COMMANDES" VALUES (11048,'2010-09-24','BOTTM'); INSERT INTO "COMMANDES" VALUES (11051,'2010-07-27','LAMAI'); INSERT INTO "COMMANDES" VALUES (11053,'2010-07-27','PICCO'); INSERT INTO "COMMANDES" VALUES (11054,'2010-03-28','CACTU'); INSERT INTO "COMMANDES" VALUES (11056,'2010-10-28','EASTC'); INSERT INTO "COMMANDES" VALUES (11057,'2010-08-29','NORTS'); INSERT INTO "COMMANDES" VALUES (11058,'2010-10-29','BLAUS'); INSERT INTO "COMMANDES" VALUES (11060,'0000-00-00','FRANS'); INSERT INTO "COMMANDES" VALUES (11062,'2010-07-30','REGGC'); INSERT INTO "COMMANDES" VALUES (11063,'2010-07-30','HUNGO'); INSERT INTO "COMMANDES" VALUES (11067,'2010-06-04','DRACD'); INSERT INTO "COMMANDES" VALUES (11070,'2010-08-05','LEHMS'); INSERT INTO "COMMANDES" VALUES (11072,'2010-11-05','ERNSH'); INSERT INTO "COMMANDES" VALUES (11076,'2010-08-06','BONAP');

INSERT INTO "PRODUITS" VALUES (1,'Chai',90.0); INSERT INTO "PRODUITS" VALUES (2,'Chang',95.0); INSERT INTO "PRODUITS" VALUES (3,'Aniseed Syrup',50.0); INSERT INTO "PRODUITS" VALUES (4,'Chef Anton''s Cajun Seasoning',110.0); INSERT INTO "PRODUITS" VALUES (5,'Chef Anton''s Gumbo Mix',106.0); INSERT INTO "PRODUITS" VALUES (6,'Grandma''s Boysenberry Spread',125.0); INSERT INTO "PRODUITS" VALUES (7,'Uncle Bob''s Organic Dried Pears',150.0); INSERT INTO "PRODUITS" VALUES (8,'Northwoods Cranberry Sauce',200.0); INSERT INTO "PRODUITS" VALUES (9,'Mishi Kobe Niku',485.0); INSERT INTO "PRODUITS" VALUES (10,'Ikura',155.0); INSERT INTO "PRODUITS" VALUES (11,'Queso Cabrales',105.0); INSERT INTO "PRODUITS" VALUES (12,'Queso Manchego La Pastora',190.0); INSERT INTO "PRODUITS" VALUES (13,'Konbu',30.0); INSERT INTO "PRODUITS" VALUES (14,'Tofu',116.0); INSERT INTO "PRODUITS" VALUES (15,'Genen Shouyu',78.0); INSERT INTO "PRODUITS" VALUES (16,'Pavlova',87.0); INSERT INTO "PRODUITS" VALUES (17,'Alice Mutton',195.0); INSERT INTO "PRODUITS" VALUES (18,'Carnarvon Tigers',313.0); INSERT INTO "PRODUITS" VALUES (19,'Teatime Chocolate Biscuits',46.0); INSERT INTO "PRODUITS" VALUES (20,'Sir Rodney''s Marmalade',405.0); INSERT INTO "PRODUITS" VALUES (21,'Sir Rodney''s Scones',50.0); INSERT INTO "PRODUITS" VALUES (27,'Schoggi Schokolade',220.0); INSERT INTO "PRODUITS" VALUES (30,'Nord-Ost Matjeshering',129.0); INSERT INTO "PRODUITS" VALUES (31,'Gorgonzola Telino',63.0); INSERT INTO "PRODUITS" VALUES (32,'Mascarpone Fabioli',160.0); INSERT INTO "PRODUITS" VALUES (33,'Geitost',13.0); INSERT INTO "PRODUITS" VALUES (34,'Sasquatch Ale',70.0); INSERT INTO "PRODUITS" VALUES (35,'Steeleye Stout',90.0); INSERT INTO "PRODUITS" VALUES (36,'Inlagd Sill',95.0); INSERT INTO "PRODUITS" VALUES (37,'Gravad lax',130.0); INSERT INTO "PRODUITS" VALUES (39,'Chartreuse verte',90.0); INSERT INTO "PRODUITS" VALUES (40,'Boston Crab Meat',92.0); INSERT INTO "PRODUITS" VALUES (41,'Jack''s New England Clam Chowder',48.0); INSERT INTO "PRODUITS" VALUES (42,'Singaporean Hokkien Fried Mee',70.0); INSERT INTO "PRODUITS" VALUES (43,'Ipoh Coffee',230.0); INSERT INTO "PRODUITS" VALUES (44,'Gula Malacca',97.0); INSERT INTO "PRODUITS" VALUES (46,'Spegesild',60.0); INSERT INTO "PRODUITS" VALUES (47,'Zaanse koeken',48.0); INSERT INTO "PRODUITS" VALUES (48,'Chocolade',64.0); INSERT INTO "PRODUITS" VALUES (49,'Maxilaku',100.0); INSERT INTO "PRODUITS" VALUES (50,'Valkoinen suklaa',81.0); INSERT INTO "PRODUITS" VALUES (51,'Manjimup Dried Apples',265.0); INSERT INTO "PRODUITS" VALUES (52,'Filo Mix',35.0); INSERT INTO "PRODUITS" VALUES (53,'Perth Pasties',164.0); INSERT INTO "PRODUITS" VALUES (56,'Gnocchi di nonna Alice',190.0); INSERT INTO "PRODUITS" VALUES (57,'Ravioli Angelo',98.0); INSERT INTO "PRODUITS" VALUES (58,'Escargots de Bourgogne',66.0); INSERT INTO "PRODUITS" VALUES (59,'Raclette Courdavault',275.0); INSERT INTO "PRODUITS" VALUES (60,'Camembert Pierrot',170.0); INSERT INTO "PRODUITS" VALUES (62,'Tarte au sucre',247.0); INSERT INTO "PRODUITS" VALUES (63,'Vegie-spread',220.0); INSERT INTO "PRODUITS" VALUES (65,'Louisiana Fiery Hot Pepper Sauce',105.0); INSERT INTO "PRODUITS" VALUES (66,'Louisiana Hot Spiced Okra',85.0); INSERT INTO "PRODUITS" VALUES (67,'Laughing Lumberjack Lager',70.0); INSERT INTO "PRODUITS" VALUES (68,'Scottish Longbreads',63.0); INSERT INTO "PRODUITS" VALUES (69,'Gudbrandsdalsost',180.0); INSERT INTO "PRODUITS" VALUES (70,'Outback Lager',75.0); INSERT INTO "PRODUITS" VALUES (72,'Mozzarella di Giovanni',174.0); INSERT INTO "PRODUITS" VALUES (74,'Longlife Tofu',50.0);

INSERT INTO "DETAILS_COMMANDES" VALUES (10248,11,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10248,42,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10248,72,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10251,57,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10251,65,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10254,74,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10258,2,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10258,5,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10258,32,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10263,16,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10263,30,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10263,74,36); INSERT INTO "DETAILS_COMMANDES" VALUES (10266,12,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10270,36,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10270,43,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10274,72,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10275,59,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10277,62,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10279,17,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10284,27,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10284,44,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10284,60,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10284,67,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10288,68,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10289,3,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10295,56,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10298,2,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10298,36,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10298,59,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10298,62,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10300,66,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10300,68,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10301,40,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10301,56,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10303,40,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10303,65,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10303,68,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10309,4,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10309,6,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10309,42,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10309,43,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10311,42,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10311,69,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10312,43,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10312,53,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10315,34,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10315,70,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10318,41,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10321,35,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10328,59,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10328,65,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10328,68,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10333,14,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10333,21,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10334,52,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10334,68,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10335,2,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10335,31,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10335,32,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10335,51,48); INSERT INTO "DETAILS_COMMANDES" VALUES (10340,18,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10340,41,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10340,43,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10343,68,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10348,1,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10350,50,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10350,69,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10351,41,13); INSERT INTO "DETAILS_COMMANDES" VALUES (10351,44,77); INSERT INTO "DETAILS_COMMANDES" VALUES (10351,65,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10353,11,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10355,57,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10356,31,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10356,69,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10358,34,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10358,36,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10359,16,56); INSERT INTO "DETAILS_COMMANDES" VALUES (10359,31,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10359,60,80); INSERT INTO "DETAILS_COMMANDES" VALUES (10362,51,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10363,31,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10364,69,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10368,21,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10368,57,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10370,1,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10370,74,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10371,36,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10373,58,80); INSERT INTO "DETAILS_COMMANDES" VALUES (10374,31,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10374,58,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10377,39,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10380,30,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10380,53,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10380,60,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10380,70,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10382,5,32); INSERT INTO "DETAILS_COMMANDES" VALUES (10382,18,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10382,33,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10382,74,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10383,13,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10383,50,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10383,56,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10388,52,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10388,53,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10389,10,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10389,62,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10389,70,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10390,31,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10390,35,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10390,46,45); INSERT INTO "DETAILS_COMMANDES" VALUES (10390,72,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10391,13,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10392,69,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10400,35,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10400,49,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10402,63,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10403,16,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10403,48,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10404,42,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10404,49,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10410,33,49); INSERT INTO "DETAILS_COMMANDES" VALUES (10410,59,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10411,41,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10411,44,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10411,59,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10412,14,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10413,1,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10413,62,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10416,19,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10416,53,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10416,57,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10427,14,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10428,46,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10429,50,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10429,63,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10430,17,45); INSERT INTO "DETAILS_COMMANDES" VALUES (10430,21,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10430,56,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10430,59,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10431,17,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10431,40,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10431,47,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10435,2,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10435,72,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10437,53,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10442,11,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10442,66,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10443,11,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10448,40,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10450,10,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10453,48,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10453,70,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10454,16,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10454,33,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10454,46,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10455,39,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10455,53,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10459,7,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10459,46,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10459,72,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10462,13,1); INSERT INTO "DETAILS_COMMANDES" VALUES (10464,4,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10464,43,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10464,56,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10464,60,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10470,18,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10471,7,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10471,56,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10472,51,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10473,33,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10478,10,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10484,21,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10484,40,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10484,51,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10489,11,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10489,16,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10491,44,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10492,42,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10493,65,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10493,66,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10493,69,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10495,41,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10497,56,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10497,72,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10500,15,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10503,14,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10503,65,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10511,4,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10511,7,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10511,8,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10513,21,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10513,32,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10514,20,39); INSERT INTO "DETAILS_COMMANDES" VALUES (10514,56,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10514,65,39); INSERT INTO "DETAILS_COMMANDES" VALUES (10516,18,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10516,41,80); INSERT INTO "DETAILS_COMMANDES" VALUES (10516,42,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10517,52,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10517,59,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10517,70,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10519,10,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10519,56,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10519,60,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10521,35,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10521,41,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10521,68,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10522,1,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10522,8,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10522,30,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10522,40,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10523,17,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10523,20,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10523,37,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10523,41,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10525,36,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10525,40,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10526,1,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10526,13,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10526,56,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10529,68,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10529,69,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10530,17,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10530,43,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10532,30,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10532,66,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10534,30,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10534,40,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10536,12,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10536,31,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10536,33,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10536,60,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10538,70,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10538,72,1); INSERT INTO "DETAILS_COMMANDES" VALUES (10539,13,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10539,21,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10539,33,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10539,49,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10546,7,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10546,35,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10546,62,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10547,32,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10547,36,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10550,17,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10550,19,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10550,21,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10551,16,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10551,35,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10551,44,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10553,11,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10553,16,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10553,31,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10553,35,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10558,47,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10558,51,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10558,52,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10558,53,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10562,33,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10562,62,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10567,31,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10567,51,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10567,59,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10571,14,11); INSERT INTO "DETAILS_COMMANDES" VALUES (10571,42,28); INSERT INTO "DETAILS_COMMANDES" VALUES (10575,59,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10575,63,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10575,72,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10578,35,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10578,57,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10582,57,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10583,60,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10583,69,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10586,52,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10592,15,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10593,20,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10593,69,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10595,35,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10595,69,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10597,57,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10597,65,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10599,62,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10604,48,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10609,1,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10609,10,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10609,21,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10610,36,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10611,1,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10611,2,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10611,60,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10614,11,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10614,21,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10614,39,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10620,52,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10621,19,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10621,70,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10632,2,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10632,33,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10633,12,36); INSERT INTO "DETAILS_COMMANDES" VALUES (10633,13,13); INSERT INTO "DETAILS_COMMANDES" VALUES (10633,62,80); INSERT INTO "DETAILS_COMMANDES" VALUES (10635,4,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10635,5,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10636,4,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10636,58,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10640,69,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10640,70,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10643,39,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10643,46,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10646,1,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10646,10,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10649,72,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10651,19,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10655,41,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10661,39,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10661,58,49); INSERT INTO "DETAILS_COMMANDES" VALUES (10663,40,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10663,42,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10663,51,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10664,10,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10664,56,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10664,65,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10667,69,45); INSERT INTO "DETAILS_COMMANDES" VALUES (10668,31,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10671,16,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10671,62,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10671,65,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10673,16,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10673,42,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10673,43,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10683,52,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10686,17,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10687,9,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10687,36,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10692,63,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10695,8,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10695,12,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10698,11,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10698,17,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10698,65,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10698,70,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10699,47,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10701,59,42); INSERT INTO "DETAILS_COMMANDES" VALUES (10702,3,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10707,57,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10707,70,28); INSERT INTO "DETAILS_COMMANDES" VALUES (10710,19,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10710,47,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10712,53,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10712,56,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10715,10,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10716,21,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10716,51,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10726,4,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10726,11,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10727,17,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10727,56,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10727,59,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10730,16,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10730,31,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10730,65,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10731,21,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10731,51,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10736,65,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10737,13,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10737,41,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10739,36,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10739,52,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10741,2,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10742,3,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10742,60,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10742,72,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10743,46,28); INSERT INTO "DETAILS_COMMANDES" VALUES (10746,13,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10746,42,28); INSERT INTO "DETAILS_COMMANDES" VALUES (10746,62,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10746,69,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10747,31,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10747,41,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10747,63,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10747,69,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10749,56,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10749,59,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10750,14,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10750,59,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10752,1,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10752,69,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10753,74,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10754,40,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10755,47,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10755,56,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10755,57,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10755,69,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10760,27,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10760,43,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10764,3,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10764,39,130); INSERT INTO "DETAILS_COMMANDES" VALUES (10768,31,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10768,60,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10772,59,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10773,17,33); INSERT INTO "DETAILS_COMMANDES" VALUES (10773,31,70); INSERT INTO "DETAILS_COMMANDES" VALUES (10776,31,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10776,42,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10776,51,120); INSERT INTO "DETAILS_COMMANDES" VALUES (10779,16,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10779,62,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10781,56,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10781,74,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10782,31,1); INSERT INTO "DETAILS_COMMANDES" VALUES (10784,36,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10784,39,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10784,72,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10787,2,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10792,2,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10792,68,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10793,41,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10793,52,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10795,16,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10795,17,35); INSERT INTO "DETAILS_COMMANDES" VALUES (10797,11,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10798,62,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10798,72,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10800,11,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10800,51,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10804,10,36); INSERT INTO "DETAILS_COMMANDES" VALUES (10804,49,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10806,2,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10806,65,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10806,74,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10807,40,1); INSERT INTO "DETAILS_COMMANDES" VALUES (10810,13,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10810,70,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10812,31,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10812,72,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10814,41,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10814,43,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10814,48,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10818,32,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10818,41,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10819,43,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10825,53,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10827,10,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10827,39,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10828,20,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10829,2,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10829,8,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10829,13,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10829,60,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10832,13,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10832,44,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10835,59,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10836,35,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10836,57,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10836,60,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10843,51,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10848,5,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10848,9,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10850,33,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10850,70,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10853,18,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10854,10,100); INSERT INTO "DETAILS_COMMANDES" VALUES (10854,13,65); INSERT INTO "DETAILS_COMMANDES" VALUES (10858,7,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10858,27,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10858,70,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10860,51,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10862,11,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10862,52,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10864,35,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10864,67,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10869,1,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10869,11,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10869,68,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10870,35,3); INSERT INTO "DETAILS_COMMANDES" VALUES (10870,51,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10871,6,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10871,16,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10871,17,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10872,62,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10872,65,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10873,21,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10874,10,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10876,46,21); INSERT INTO "DETAILS_COMMANDES" VALUES (10879,40,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10879,65,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10888,2,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10888,68,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10890,17,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10890,34,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10890,41,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10891,30,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10892,59,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10895,39,45); INSERT INTO "DETAILS_COMMANDES" VALUES (10895,40,91); INSERT INTO "DETAILS_COMMANDES" VALUES (10895,60,100); INSERT INTO "DETAILS_COMMANDES" VALUES (10896,56,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10897,30,36); INSERT INTO "DETAILS_COMMANDES" VALUES (10908,7,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10908,52,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10910,19,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10910,49,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10911,1,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10911,17,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10911,67,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10912,11,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10916,16,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10916,32,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10916,57,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10918,1,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10918,60,25); INSERT INTO "DETAILS_COMMANDES" VALUES (10920,50,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10923,42,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10923,43,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10923,67,24); INSERT INTO "DETAILS_COMMANDES" VALUES (10927,20,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10927,52,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10932,16,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10932,62,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10932,72,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10933,53,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10934,6,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10937,34,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10939,2,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10939,67,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10940,7,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10940,13,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10942,49,28); INSERT INTO "DETAILS_COMMANDES" VALUES (10943,13,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10943,46,15); INSERT INTO "DETAILS_COMMANDES" VALUES (10944,11,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10944,44,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10944,56,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10945,13,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10945,31,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10947,59,4); INSERT INTO "DETAILS_COMMANDES" VALUES (10948,50,9); INSERT INTO "DETAILS_COMMANDES" VALUES (10948,51,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10949,6,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10949,10,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10949,17,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10949,62,60); INSERT INTO "DETAILS_COMMANDES" VALUES (10950,4,5); INSERT INTO "DETAILS_COMMANDES" VALUES (10952,6,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10953,20,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10953,31,50); INSERT INTO "DETAILS_COMMANDES" VALUES (10956,21,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10956,47,14); INSERT INTO "DETAILS_COMMANDES" VALUES (10956,51,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10963,60,2); INSERT INTO "DETAILS_COMMANDES" VALUES (10966,37,8); INSERT INTO "DETAILS_COMMANDES" VALUES (10966,56,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10966,62,12); INSERT INTO "DETAILS_COMMANDES" VALUES (10968,12,30); INSERT INTO "DETAILS_COMMANDES" VALUES (10972,17,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10972,33,7); INSERT INTO "DETAILS_COMMANDES" VALUES (10973,41,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10975,8,16); INSERT INTO "DETAILS_COMMANDES" VALUES (10978,8,20); INSERT INTO "DETAILS_COMMANDES" VALUES (10978,21,40); INSERT INTO "DETAILS_COMMANDES" VALUES (10978,40,10); INSERT INTO "DETAILS_COMMANDES" VALUES (10978,44,6); INSERT INTO "DETAILS_COMMANDES" VALUES (10979,7,18); INSERT INTO "DETAILS_COMMANDES" VALUES (10979,12,20); CREATE INDEX IF NOT EXISTS "DETAILS_COMMANDES_REF_PRODUIT" ON "DETAILS_COMMANDES" ( "REF_PRODUIT" ); CREATE INDEX IF NOT EXISTS "PRODUITS_NOM_PRODUIT" ON "PRODUITS" ( "NOM_PRODUIT" ); CREATE INDEX IF NOT EXISTS "COMMANDES_CODE_CLIENT" ON "COMMANDES" ( "CODE_CLIENT" ); COMMIT;

(2) By NotSpecialist on 2021-11-29 12:01:58 in reply to 1 [source]

Here's the file (.sql):

https://www.mediafire.com/file/35fa3825r74co2l/facturation_simple.sql/file

Question : "Give the total of the invoice no_command '10248'. Note, we can obtain the product of two attributes with: *"

(FR)Client = Customer/Produit = Product no_commande = Order number (of the command), societe/code_postal/pays/categorie not needed ref_produit = product reference/quantite =quantity (really useful I guess) PRIX_UNITAIRE = Unit Price NOM_PRODUIT = PRODUCT_NAME (Copy paste) ------->

If you need informations, tell me.

(3) By Simon Slavin (slavin) on 2021-11-29 16:26:42 in reply to 1 [link] [source]

One day, we should actually do someone's homework for them. You know … just to mess with them.