insert into clientes values(1,'nestle','alfonso','secretario','samanes 7','Guayaquil','costa',124,'Ecuador',0986505594,'1245fgh');
insert into clientes values(2,'pamesa','rodolfo','inspector','jimena 2','babahoyo','costa',785,'Ecuador',0985462134,'7845ddgh');
insert into clientes values(3,'fontestad','ricardo','director','pueblo nuevo','babahoyo','costa',365,'Ecuador',0985421632,'457fjt');
insert into clientes values(4,'prieto','alejandro','gerente','mata de cacao','babahoyo','costa',412,'Ecuador',0986505594,'7563fgh');
insert into clientes values(5,'anecoop','Judas','contador','ambato','ambato','sierra',789,'Ecuador',0975369841,'1refgh');
insert into clientes values(6,'babaria','Maria','secretaria','guambalo','amabato','sierra',258,'Ecuador',0985236457,'1945fgh');
insert into clientes values(7,'cateca','wendy','economista','la union','babahoyo','costa',456,'Ecuador',0963236598,'69875fgh');
insert into clientes values(8,'meyer','julia','directiva','mata de cacao','babahoyo','costa',2457,'Ecuador',0947852145,'63255fgh');
insert into clientes values(9,'pyca','Katerine','administradora','pimocha','babahoyo','costa',7854,'Ecuador',0963625678,'9965fgh');
insert into clientes values(10,'kamaz','Beatriz','directiva','pueblo nuevo','babahoyo','costa',7854,'Ecuador',0896321456,'93245fgh');
insert into clientes values(11,'AKI','jardel caballero','Gerente','babahoyo','babahoyo','costa',593,'Ecuador',098546654,'fax');
insert into clientes values(12,'TIA','Jessica Villala','Administradora','babahoyo','babahoyo','costa',593,'Ecuador',0994921254,'fax');
insert into clientes values(13,'Comisariato','Daniel Tirape','Director Administrativo','Guayaquil','Guayaquil','costa',593,'Ecuador',0954789612,'fax');
insert into clientes values(14,'AKI','jardel caballero','Gerente','babahoyo','babahoyo','costa',593,'Ecuador',098546654,'fax');
insert into clientes values(15,'TIA','Jessica Villala','Administradora','babahoyo','babahoyo','costa',593,'Ecuador',0994921254,'fax');
insert into Clientes values(16,'El Maestro','Juana', 'secretario','Guayaquil y Ricaurte','Loja','Sierra',1452,'Ecuador',965896,965896);
insert into Clientes values(17,'El Panita 2','Pedro', 'secretario','Daule y Sucre','Vinces','Costa',1525,'Ecuador',258746,258746);
insert into Clientes values(18,'Tia S.A','Nicolas', 'secretario','Diez de Agosto','Babahoyo','Costa',1235,'Ecuador',325478,325478);
insert into Clientes values(19,'Sunny S.A','Stefania', 'secretario','Bolivar y Ricaurte','Salitre','Costa',1889,'Ecuador',189658,189658);
insert into Clientes values(20,'Agua Cielo S.A','Jose', 'secretario','Juan y quito','Quito','sierra',14452,'Ecuador',232352,232352);
INSERT INTO Clientes VALUES (21,'Coorporacion el Rosado','Jose Rosado','Gerente','Avenida Universitaria','Babahoyo','Costa',125486,'Ecuador',254789,'546879');
INSERT INTO Clientes VALUES (22,'Super AKI','Carlos Mendez','Jefe','Nicaragua','Vinces','Costa',154687,'Ecuador',254789,'546975');
INSERT INTO Clientes VALUES (23,'Comisariato Escobar','Ronald Villavicencio','Cajero','Barreiro y Garcia Moreno','Babahoyo','Costa',009564,'Ecuador',733738,'Ninguno');
INSERT INTO Clientes VALUES (24,'Dismero','Miguel Cordoba','Gerente','Perimetral','Guayaquil','Costa',005478,'Ecuador',758698,'254568');
INSERT INTO Clientes VALUES (25,'TIA','Belen Benitez','Jefa','Lotizacion Zuñiga','Babahoyo','Costa',004785,'Ecuador',557866,'Ninguno');
insert into clientes values(26,'Coca Cola','Stalin', 'Bodegero','Sucre','Quito','Sierra',1234,'Ecuador',971005,971005);
insert into clientes values(27,'Pepsi','Israel', 'secretario','Velazco Ibarra y 10 de Agosto','Babahoyo','Costa',4567,'Ecuador',972994,972994);
insert into clientes values(28,'Comedor Olguita','Wilber', 'Gerente','El centro','Guayaquil','Costa',7890,'Ecuador',746473,746473);
insert into clientes values(29,'Billar el Punto','Nain', 'Gerente','Sector Hospital','Ventanas','Costa',0987,'Ecuador',993757,9993757);
insert into clientes values(30,'Picca','Luis', 'Administrador','La Gloria','Baños','sierra',7654,'Ecuador',699874,699874);
insert into clientes values(31,'HIPERMARKET','CRISTIAN GUEVARA','DIRECTORA','babahoyo','babahoyo','costa',593,'Ecuador',098546654,'fax');
insert into clientes values(32,'SUPERPACO','ANDREA LUCIO','SECRETARIA','babahoyo','babahoyo','costa',593,'Ecuador',0994921254,'fax');
insert into clientes values(33,'SUPERMAXI','JORGE MONTENEGRO','RECURSOS HUMANOS ','Guayaquil','Guayaquil','costa',593,'Ecuador',0954789612,'fax');
insert into clientes values(34,'MEGAMAXI','LAURA TROYA','Gerente','babahoyo','babahoyo','costa',593,'Ecuador',098546654,'fax');
insert into clientes values(35,'DOÑA MARIA','GABRIELA GUZMAN','Administradora','babahoyo','babahoyo','costa',593,'Ecuador',0994921254,'fax');
insert into Clientes values (36,'yanbal', 'lorenzo alvarado', 'secretario', '5 de junio y olmedo', 'babahoyo', 'costa', '008764', 'ecuador', '089765', '089765');
insert into Clientes values (37,'avon', 'karen benitez', 'gerente', 'rocafuerte', 'ventanas', 'costa', '003462', 'ecuador', '098323', '098323');
insert into Clientes values (38,'esika', 'gilda caregua', 'jefe', 'olmedo', 'quevedo', 'costa', '0028312', 'ecuador', '0492837', '0492837');
insert into Clientes values (39,'cy zone', 'graciela bajaña', 'administrador', 'lotizacion zuñiga', 'babahoyo', 'costa', '094823', 'ecuador', '038471', '038471');
insert into Clientes values (40,'lbel', 'lester villalva', 'asesor', 'juan x marcos', 'babahoyo', 'costa', '094831', 'ecuador', '123453', '123453');
INSERT INTO Clientes VALUES (41,'Ron Automoviles', 'Pablo Pazmiño','Director','Jose Escobedo','San Cristobal Laguna','Norte',004567,'Mexico',732145,'732145');
INSERT INTO Clientes VALUES (42,'Volkswagen', 'Dario Montoya','Gerente','Urdesa','Guayaquil','Costa',005678,'Ecuador',715468,'715468');
INSERT INTO Clientes VALUES (43,'MAPFRE ATLAS', 'Vicente Mendoza','Ejecutivo','Av.La Prensa 4586','Riobamba','Sierra',0067452,'Venezuela',755765,'755765');
INSERT INTO Clientes VALUES (44,'AUTOMOTORES S.A.','Javier Miranda','Encargado','Av. Cevallos y 5 de junio','Ambato','Sierra',007124,'Chile',747759,'747759');
INSERT INTO Clientes VALUES (45,'Chevrolet', 'Pablo Pazmiño','Director','Jose Escobedo','Pastaza','Oriente',009123,'Argentina',745964,'745964');
insert into clientes values(46,'Freixenet Sa','Dayana', 'secretario','Luis Porta Lupe y Calle H','babahoyo','costa',1374,'Ecuador',5754486,5754486);
insert into clientes values(47,'Gonzalez Byass Sa','Jordi', 'secretario','Ignacio Cabrera y Velazco Ibarra','Cuenca','sierra',3402,'Ecuador',98745,98745);
insert into clientes values(48,'Bodegas Marques Sa','Tomas', 'secretario','Seminario y malecon','babahoyo','costa',4707,'Ecuador',698774,698774);
insert into clientes values(49,'La Rioja Alta Sa','Fanny', 'secretario','Cris Valle y Lola','Ibarra','sierra',3469,'Ecuador',987415,987415);
insert into clientes values(50,'Pagos Del Rey Sl','Carlos', 'secretario','Pasito Perron','Guaranda','sierra',1734,'Ecuador',699874,699874);
insert into clientes values(51,'dismero','Mariana','secretaria','Esmeraldas','montalvo','costa',201,'Ecuador',0985467770,'542dc');
insert into clientes values(52,'supermaxi','Denisse','supervisora','Ventanas','babahoyo','costa',302,'Ecuador',0994925724,'fax');
insert into clientes values(53,'supereco','Jose','gerente general','Duran','Guayaquil','costa',400,'Ecuador',0954789765,'126ghn');
insert into clientes values(54,'manzano','Beatriz','administradora','Jujan','babahoyo','costa',203,'Ecuador',098546897,'4568red');
insert into clientes values(55,'toni','Ernesto','recepsionista','Pisagua','Montalvo','costa',100,'Ecuador',0994921245,'958wiut');
INSERT INTO companias_de_envios VALUES(1,'Servientrega',027456821);
INSERT INTO companias_de_envios VALUES(2,'Correos del Ecuador',052716012);
INSERT INTO companias_de_envios VALUES(3,'WesterJunior',042175621);
INSERT INTO companias_de_envios VALUES(4,'DHL Express',024587962);
INSERT INTO companias_de_envios VALUES(5,'FedEx Express',052754896);
insert into companias_de_envios values(6,'Amazon',052754712);
insert into companias_de_envios values(7,'TRASANDINA',052729173);
insert into companias_de_envios values(8,'fastentrega',042716548);
insert into companias_de_envios values(9,'Discosby',032557962);
insert into companias_de_envios values(10,'FedEx',052255962);
insert into companias_de_envios values(11,'Globalexs',052557962);
insert into companias_de_envios values(12,'redpack',022745689);
insert into companias_de_envios values(13,'ebox',042525872);
insert into companias_de_envios values(14,'multipack',042719856);
insert into companias_de_envios values(15,'rapientrega',052271475);
insert into empleados values(1,'Caballero','jardel','director','empleado','10/08/1996','12/04/2017','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','rafael correa');
insert into empleados values(2,'torres','cristobal','administrador','empleado','10/07/1996','22/04/2017','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','leon talban');
insert into empleados values(3,'suarez','leonidas','guardia','empleado','09/05/1996','05/01/2017','mata de cacao','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','luis guaman');
insert into empleados values(4,'jimenez','jose','recepcionista','empleado','02/03/1994','15/09/2016','mata de cacao','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','jhon travolta');
insert into empleados values(5,'Carrillo','luis','director','empleado','24/10/1995','02/02/2015','febres cordero','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','rafael correa');
insert into empleados values(6,'del barco','ronny','guardia','empleado','19/04/1993','12/09/2015','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','julio tooma');
insert into empleados values(7,'gastesi','juana','director','empleado','21/09/1995','21/06/2015','la union','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','johnny teran');
insert into empleados values(8,'junco','mariela','recepcionista','empleado','26/04/1995','22/03/2014','caracol','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','maros troya');
insert into empleados values(9,'toalombo','marcia','vendedor','empleado','02/06/1996','30/04/2015','pimocha','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','lenin moreno');
insert into empleados values(10,'Cevallos','fabian','vendedor','empleado','11/08/1995','03/04/2015','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','jorge glass');
insert into empleados values(11,'prieto','zaa','guardia','empleado','10/02/1993','19/07/2015','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','julio tooma');
insert into empleados values(12,'delpozo','juan','director','empleado','22/09/1995','04/06/2015','la union','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','johnny teran');
insert into empleados values(13,'benitex','maria','recepcionista','empleado','24/01/1995','23/01/2014','caracol','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','maros troya');
insert into empleados values(14,'valverde','steffy','vendedor','empleado','07/04/1996','21/04/2015','pimocha','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','lenin moreno');
insert into empleados values(15,'jimenez','lorenzo','vendedor','empleado','14/08/1995','11/04/2015','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','jorge glass');
insert into Empleados values(16,'Rivera','Roberto','Bodeguero','nose','20/05/1990','20/02/2010','Sucre callejon 2','Vinces','Costa',58589,'Ecuador',04552486,'593','Excelente','Gerente');
insert into Empleados values(17,'Monserrates','Juan','Despachador','nose','10/10/1991','02/06/2015','Ciudadela nvida','Guayaquil','Costa',96585,'Ecuador',0255986,'574','Bueno','Dueño');
insert into Empleados values(18,'Guayaquil','Laura','Secretaria','nose','05/02/1994','01/01/2015','Las malvinas','Riobamba','Sierra',12548,'Ecuador',052144589,'578','MuyBueno','Gerente');
insert into Empleados values(19,'Quintana','Veronica','Pechero','nose','09/03/1990','12/12/2011','Bolivar diagonal al banco Pichincha','Babahoyo','Costa',25254,'Ecuador',058954475,'525','Bueno','gerente');
insert into Empleados values(20,'Maldonado','Mirian','Repartidor','nose','20/03/1991','14/02/2014','Esmelada y quito','Salitre','Costa',22554,'Ecuador',025898986,'588','Exelente','Dueño');
INSERT INTO Empleados VALUES(21,'Caregua Mendez','Yamilex','Cajera1','Bueno',to_date('07/12/1995','dd/mm/yyyy'),to_date('13/10/2010','dd/mm/yyyy'),'Nicaragua','Vinces','Costa',001485,'Ecuador',0982729586,'Milagro','Ninguna','No');
INSERT INTO Empleados VALUES(22,'Pazmiño Sudario','Angie','Cajera2','Regular',to_date('17/04/1995','dd/mm/yyyy'),to_date('14/09/2016','dd/mm/yyyy'),'Barreiro','Babahoyo','Costa',006557,'Ecuador',0989130805,'Guayaquil','Ninguna','No');
INSERT INTO Empleados VALUES(23,'Benitez Soriano','Maria','Bodeguera','Muy Bueno',to_date('12/05/1994','dd/mm/yyyy'),to_date('12/10/2012','dd/mm/yyyy'),'Lotizacion Zuñiga','Babahoyo','Costa',021145,'Ecuador',0990236848,'Quito','Ninguna','No');
INSERT INTO Empleados VALUES(24,'Vera','Jose','Perchero','Bueno',to_date('16/06/1995','dd/mm/yyyy'),to_date('25/05/2006','dd/mm/yyyy'),'10 de Agosto','Vinces','Costa',210025,'Ecuador',0928256542,'Cuenca','Ninguna','No');
INSERT INTO Empleados VALUES(25,'Jimenez Vergara','Israel','Personal de Aseo','Regular',to_date('12/12/1990','dd/mm/yyyy'),to_date('14/01/2009','dd/mm/yyyy'),'5 de Junio','Ventanas','Costa',254526,'Ecuador',0958754785,'Ninguna','Ninguna','No');
insert into Empleados values(26,'Rendon','Antonio','Gerente','NO','28/09/1993','10/07/2009','calle A y calle B','Ventanas','costa',65879,'ecuador',052097643,'NO','Exelente','Gerente');
insert into Empleados values(27,'Castro','Jose','Administrador','NO','18/09/1993','20/11/2010','La Gloria','Ventanas','costa',685747,'ecuador',052765445,'NO','bueno','Gerente');
insert into Empleados values(28,'Maldonado','Stalin','Bodeguero','NO','09/06/1985','20/10/2014','La decima','Ventanas','costa',12547,'ecuador',052775421,'NO','bueno','Gerente');
insert into Empleados values(29,'Guerrero','Fernando','Bodeguero','NO','17/12/1989','01/12/1999','Nuevo Asentamiento','Ventanas','costa',12587,'ecuador',052991118,'NO','Regular','Gerente');
insert into Empleados values(30,'Freire','Joselin','Contadora','NO','19/07/1997','29/01/2000','Loma 1','Ventanas','costa',69774,'ecuador',052858200,'NO','bueno','Gerente');
insert into empleados values(31,'ROCA','MARCOS','CHOFER','empleado','10/05/1991','19/07/2016','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','julio tooma');
insert into empleados values(32,'MARTINES','GABRIELA','director','empleado','25/12/1995','04/06/2015','la union','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','johnny teran');
insert into empleados values(33,'MERA','DIANA','SECRETARIA','empleado','24/07/1993','23/01/2017','caracol','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','maros troya');
insert into empleados values(34,'SANDOYA','MIGUEL','vendedor','empleado','07/09/1996','21/04/2016','pimocha','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','lenin moreno');
insert into empleados values(35,'VELAZCO','JAVIER','vendedor','empleado','14/10/1995','11/04/2017','pueblo nuevo','babahoyo','costa',124,'ecuador',2716329,'babahoyo','ninguna','jorge glass');
insert into Empleados values(36, 'Cabeza', 'Maria','Secretaria', 'regular', to_date('13/09/1993','dd/mm/yyyy') , to_date('15/01/2014','dd/mm/yyyy'),'Ricaute', 'Babahoyo', 'Costa', 0947283, 'Ecuador', 738291, 'Guayaquil', 'Ninguna','No');
insert into Empleados values(37, 'Diaz', 'Irvin','Administrador', 'bueno', to_date('10/09/1991','dd/mm/yyyy') , to_date('20/02/2015','dd/mm/yyyy'),'9 de noviembre', 'Babahoyo', 'Costa', 0947283, 'Ecuador', 984923, 'Cuenca', 'Ninguna','No');
insert into Empleados values(38, 'Pazmiño', 'Angie','Asistente', 'regular', to_date('17/04/1995','dd/mm/yyyy') , to_date('16/03/2016','dd/mm/yyyy'),'Barreiro y Garcia moreno', 'Babahoyo', 'Costa', 0937283, 'Ecuador', 7631823, 'Manta', 'Ninguna','No');
insert into Empleados values(39, 'Soriano', 'Martha','Jefe', 'bueno', to_date('03/03/1971','dd/mm/yyyy') , to_date('25/06/2008','dd/mm/yyyy'),'27 de mayo y 5 de junio', 'Babahoyo', 'Costa', 0837293, 'Ecuador', 928321, 'Portoviejo', 'Ninguna','Si');
insert into Empleados values(40, 'Cujilan', 'Kerly','Gerente', 'regular', to_date('14/09/1990','dd/mm/yyyy') , to_date('08/07/2013','dd/mm/yyyy'),'10 de agosto', 'Babahoyo', 'Costa', 097261, 'Ecuador', 734563, 'Quito', 'Ninguna','No');
INSERT INTO Empleados VALUES(41,'Eheverria','Maria','Conserje','Regular',to_date('18/09/1996','dd/mm/yyyy'),to_date('14/09/2014','dd/mm/yyyy'),'Ibarra y Babahoyo','Santo Domingo','Sierra',054687,'Ecuador',731732,'Quito','Ninguna','No');
INSERT INTO Empleados VALUES(42,'Palma Fernandez','Geovanna','Secretaria','Muy Buena',to_date('15/05/1994','dd/mm/yyyy'),to_date('01/01/2016','dd/mm/yyyy'),'Barreiro y Garcia Moreno','Babahoyo','Costa',0098454,'Peru',7894512,'Ninguna','Ninguna','No');
INSERT INTO Empleados VALUES(43,'Pincay Suarez','Estefania','Recepcionista','Buena',to_date('21/06/1993','dd/mm/yyyy'),to_date('09/11/2012','dd/mm/yyyy'),'Trinity','Guayaquil','Costa',334568,'Uruguay',741258,'Ninguna','Ninguna','No');
INSERT INTO Empleados VALUES(44,'Pincay Mora','Valeria','Gerente','Excelente',to_date('28/11/1990','dd/mm/yyyy'),to_date('30/05/2007','dd/mm/yyyy'),'10 de Agosto','Napo','Oriente',999452,'Colombia',796325,'Ninguna','Ninguna','No');
INSERT INTO Empleados VALUES(45,'Alarcon Sanchez','Emiliano','Supervisor','Eficiente',to_date('06/03/1992','dd/mm/yyyy'),to_date('25/08/2010','dd/mm/yyyy'),'Mexico y Guayaquil','Quito','Sierra',111245,'Estados Unidos',745632,'Ninguna','Ninguna','No');
insert into Empleados values(46,'Jimenez','Israel','Bodeguero','xxxx','11/04/1993','10/03/2010','malibu Croter 587','Cuenca','costa',65879,'ecuador',052970665,'xxxx','bueno','gerente');
insert into Empleados values(47,'Vergara','Ernesto','Bodeguero','xxxx','18/05/1997','20/02/2012','calle sin nombre con otra','Ambato','costa',685747,'ecuador',052973664,'xxxx','bueno','gerente');
insert into Empleados values(48,'Quinones','Tefa','Bodeguero','xxxx','19/09/1975','30/01/2014','Pitufo y Cabreado','Ambato','sierra',12547,'ecuador',05297198,'xxxx','bueno','gerente');
insert into Empleados values(49,'Cruz','Fany','Bodeguero','xxxx','07/08/1986','12/12/2011','Enger Grow y Baticueba','Shushufindi','amazonia',12587,'ecuador',052972041,'xxxx','bueno','gerente');
insert into Empleados values(50,'Gallego','Laura','Bodeguero','xxxx','19/07/1992','25/04/2014','Pichirilo y pasto','Ventanas','costa',69774,'ecuador',052973588,'xxxx','bueno','gerente');
insert into empleados values(51,'Verdezoto','Ariana','gerente','empleado','20/08/2010','02/03/2017','Vinces','babahoyo','costa',126,'ecuador',2716458,'babahoyo','ninguna','Rita Castro');
insert into empleados values(52,'Veloz','Geovanna','supervisor','empleado','10/07/1999','12/09/2017','La union','babahoyo','costa',126,'ecuador',2716896,'babahoyo','ninguna','Favian Arias');
insert into empleados values(53,'Soria','Luis','cajera','empleado','19/05/1998','15/11/2017','Montalvo','babahoyo','costa',126,'ecuador',2716789,'babahoyo','ninguna','Luisana Velez');
insert into empleados values(54,'Gaibor','Pedro','organizadora','empleado','02/09/1995','21/10/2017','montalvo','babahoyo','costa',126,'ecuador',2716879,'babahoyo','ninguna','Luis Mora');
insert into empleados values(55,'Fuentes','Cesar','director','empleado','04/10/1999','12/12/2017','La union','babahoyo','costa',126,'ecuador',2716456,'babahoyo','ninguna','Maria Veloz');
insert into Pedidos values(1,1,1,1,'07/05/2017','09/09/2017','06/04/2017','secretario','ronald','samanes7','Guayaquil','costa',12,'Ecuador');
insert into Pedidos values(2,2,2,1,'04/06/2017','10/07/2017','06/04/2017','gerente','angel','samanes4','Babahoyo','costa',15,'Ecuador');
insert into Pedidos values(3,2,3,1,'03/01/2017','12/08/2017','06/04/2017','encargado','jardel','samanes3','Cuenca','costa',10,'Ecuador');
insert into Pedidos values(4,3,4,1,'01/03/2017','22/04/2017','06/04/2017','concerje','andrea','samanes1','Azogues','costa',14,'Ecuador');
insert into Pedidos values(5,6,5,1,'06/05/2017','21/06/2017','06/04/2017','oficinista','consuelo','samanes','Quito','sierra',4,'Ecuador');
insert into Pedidos values(6,3,6,1,'21/09/2017','23/09/2017','06/04/2017','guardia','pepito','samanes10','Manta','costa',9,'Ecuador');
insert into Pedidos values(7,1,7,1,'22/07/2017','25/07/2017','06/04/2017','recepcionista','alfonso','samanes11','salinas','costa',3,'Ecuador');
insert into Pedidos values(8,5,8,1,'23/04/2017','17/06/2017','06/04/2017','mensajero','juan','samanes7','Guayaquil','costa',2,'Ecuador');
insert into Pedidos values(9,4,9,1,'30/04/2017','19/02/2017','06/04/2017','secretario','carlos','samanes7','esmeraldas','costa',3,'Ecuador');
insert into Pedidos values(10,1,10,1,'05/06/2017','18/03/2017','06/04/2017','concerje','mario','samanes7','manabi','costa',365,'Ecuador');
insert into Pedidos values(11,15,10,1,'01/03/2017','21/09/2017','06/04/2017','secretario','luis','samanes8','sanpedro','costa',235,'Ecuador');
insert into Pedidos values(12,14,11,1,'08/06/2017','22/04/2017','06/04/2017','secretario','marcos','samanes9','ruminahui','sierra',111,'Ecuador');
insert into Pedidos values(13,13,8,1,'10/07/2017','08/06/2017','06/04/2017','secretario','alonso','samanes10','otavalo','sierra',122,'Ecuador');
insert into Pedidos values(14,12,4,1,'11/09/2017','04/02/2017','06/04/2017','secretario','feo','samanes3','tulcan','costa',121,'Ecuador');
insert into Pedidos values(15,11,2,1,'13/11/2017','09/01/2017','06/04/2017','secretario','maria','samanes2','loja','sierra',120,'Ecuador');
insert into Pedidos values(16,1,1,1,'20/02/2017','22/02/2017','21/02/2017','nose','Jose','Nueva primavera','Vinces','Costa',89858,'Ecuador');
insert into Pedidos values(17,2,2,2,'19/02/2017','21/02/2017','20/02/2017','nose','Maria','La z y la r','Quto','Sierra',47458,'ecuador');
insert into Pedidos values(18,3,3,3,'14/02/2017','15/02/2017','15/02/2017','nose','Juan','Av emelexista','Salitre','Costa',45758,'Ecuador');
insert into Pedidos values(19,4,4,4,'15/04/2017','16/04/2017','15/02/2017','nose','Jesus','Sucre y guayaquil','Vinces','Costa',12345,'Ecuador');
insert into Pedidos values(20,5,5,5,'16/04/2017','17/04/2017','16/02/2017','nose','Mario','Primero de junio','Baba','Costa',14525,'Ecuador');
INSERT INTO Pedidos VALUES(21,1,1,1,to_date('30/04/2017','dd/mm/yyyy'),to_date('20/05/2017','dd/mm/yyyy'),to_date('20/05/2017','dd/mm/yyyy'),'Ninguno','Comisariato Escobar','Rocafuerte','Montalvo','Costa','001547','Ecuador');
INSERT INTO Pedidos VALUES(22,2,2,2,to_date('12/01/2017','dd/mm/yyyy'),to_date('10/05/2017','dd/mm/yyyy'),to_date('09/05/2017','dd/mm/yyyy'),'Ninguno','TIA','Nicaragua','Vinces','Costa','001252','Brasil');
INSERT INTO Pedidos VALUES(23,3,1,3,to_date('15/02/2017','dd/mm/yyyy'),to_date('24/05/2017','dd/mm/yyyy'),to_date('23/05/2017','dd/mm/yyyy'),'Ninguno','Super AKI','10 de Agosto','Guayaquil','Costa','214587','Ecuador');
INSERT INTO Pedidos VALUES(24,4,4,4,to_date('01/01/2017','dd/mm/yyyy'),to_date('21/06/2017','dd/mm/yyyy'),to_date('20/06/2017','dd/mm/yyyy'),'Ninguno','Comisariato Angelito','Rocafuerte','Cuenca','Costa','215455','Ecuador');
INSERT INTO Pedidos VALUES(25,5,5,5,to_date('17/04/2017','dd/mm/yyyy'),to_date('15/06/2017','dd/mm/yyyy'),to_date('14/06/2017','dd/mm/yyyy'),'Ninguno','Eduardo','Ricaurte','Babahoyo','Costa','254588','Ecuador');
insert into Pedidos values(26,1,10,20,'01/02/2017','08/02/2017','09/02/2017','Ninguno','Stalin','La Venus','Quevedo','costa',11456,'Ecuador');
insert into Pedidos values(27,2,11,21,'10/04/2017','17/04/2017','18/04/2017','Ninguno','Antonio','Bicoca','Babahoyo','costa',54322,'Ecuador');
insert into Pedidos values(28,3,12,22,'18/01/2017','22/01/2017','23/01/2017','Ninguno','Tomas','Las Palmeras','Buena Fe','costa',45676,'Ecuador');
insert into Pedidos values(29,4,13,23,'22/03/2017','25/03/2017','26/03/2017','Ninguno','Janothan','Los Girasoles','Vinces','costa',90096,'Ecuador');
insert into Pedidos values(30,14,14,24,'28/04/2017','01/04/2017','02/04/2017','Ninguno','Jose','Barrio Cuba','Valencia','costa',99876,'Euador');
insert into Pedidos values(31,15,10,1,'01/03/2017','21/09/2017','06/04/2017','secretario','rene','sauces5','ventanas','costa',235,'Ecuador');
insert into Pedidos values(32,20,13,1,'08/06/2017','22/04/2017','06/04/2017','secretario','juan','sauces4','quito','sierra',111,'Ecuador');
insert into Pedidos values(33,6,8,1,'10/07/2017','08/06/2017','06/04/2017','secretario','mario','sauces3','manta','costa',122,'Ecuador');
insert into Pedidos values(34,34,4,1,'11/09/2017','04/02/2017','06/04/2017','secretario','jorge','sauces2','olon','costa',121,'Ecuador');
insert into Pedidos values(35,10,2,1,'13/11/2017','09/01/2017','06/04/2017','secretario','maria','sauces','loja','sierra',120,'Ecuador');
insert into Pedidos values(36,1,1,1, to_date('08/08/2017', 'dd/mm/yyyy'), to_date('16/08/2017', 'dd/mm/yyyy'), to_date('15/08/2017', 'dd/mm/yyyy'), 'gerente', 'yanbal', 'Juan Montalvo', 'Cuenca', 'Sierra', 093813, 'Ecuador' );
insert into Pedidos values(37,2,2,2, to_date('05/07/2017', 'dd/mm/yyyy'), to_date('18/07/2017', 'dd/mm/yyyy'), to_date('17/07/2017', 'dd/mm/yyyy'), 'secretario', 'esika', '6 de octubre', 'Manta', 'Costa', 094738, 'Ecuador' );
insert into Pedidos values(38,3,3,3, to_date('10/05/2017', 'dd/mm/yyyy'), to_date('20/05/2017', 'dd/mm/yyyy'), to_date('19/05/2017', 'dd/mm/yyyy'), 'Jefe', 'avon', 'El salto', 'Guayaquil', 'Costa', 092712, 'Ecuador' );
insert into Pedidos values(39,4,4,4, to_date('15/06/2017', 'dd/mm/yyyy'), to_date('27/06/2017', 'dd/mm/yyyy'), to_date('26/06/2017', 'dd/mm/yyyy'), 'Administrador', 'cy zone', 'Barrio Lindo', 'Babahoyo', 'Costa', 0847234, 'Ecuador' );
insert into Pedidos values(40,5,5,5, to_date('20/04/2017', 'dd/mm/yyyy'), to_date('30/04/2017', 'dd/mm/yyyy'), to_date('29/04/2017', 'dd/mm/yyyy'), 'Asistente', 'lbel', 'Flores', 'Babahoyo', 'Costa', 0948241, 'Ecuador' );
INSERT INTO Pedidos VALUES (41,2,3,4,to_date('15/01/2017','dd/mm/yyyy'),to_date('01/04/2017','dd/mm/yyyy'),to_date('30/03/2017','dd/mm/yyyy'),'Ninguno','Volkswagen','Urdesa','Guayaquil','Costa',005678,'Ecuador');
INSERT INTO Pedidos VALUES (42,3,4,5,to_date('20/03/2016','dd/mm/yyyy'),to_date('14/09/2016','dd/mm/yyyy'),to_date('20/08/2016','dd/mm/yyyy'),'Ninguno','Ron Automoviles','Jose Escobedo','San Cristobal Laguna','Norte',004567,'Mexico');
INSERT INTO Pedidos VALUES (43,1,5,2,to_date('10/05/2015','dd/mm/yyyy'),to_date('16/06/2015','dd/mm/yyyy'),to_date('18/05/2015','dd/mm/yyyy'),'Ninguno','MAPFRE ATLAS','Av.La Prensa 4586','Riobamba','Sierra',0067452,'Venezuela');
INSERT INTO Pedidos VALUES (44,5,1,3,to_date('25/08/2014','dd/mm/yyyy'),to_date('28/10/2014','dd/mm/yyyy'),to_date('10/09/2014','dd/mm/yyyy'),'Ninguno','Chevrolet','Jose Escobedo','Pastaza','Oriente',009123,'Argentina');
INSERT INTO Pedidos VALUES (45,4,2,1,to_date('05/11/2013','dd/mm/yyyy'),to_date('05/12/2013','dd/mm/yyyy'),to_date('30/11/2013','dd/mm/yyyy'),'Ninguno','AUTOMOTORES S.A.','Av. Cevallos y 5 de junio','Ambato','Sierra',005678,'Chile');
insert into Pedidos values(46,1,15,1,'07/04/2017','07/05/2017','06/05/2017','ninguno','Hansel','malibu Croter 587','Babahoyo','costa',98745,'ecuador');
insert into Pedidos values(47,2,10,2,'17/04/2017','07/05/2017','06/05/2017','ninguno','Gretel','calle sin nombre con otra','Esmeraldas','sierra',98745,'ecuador');
insert into Pedidos values(48,3,11,3,'18/04/2017','07/05/2017','06/05/2017','ninguno','Tomy','Pitufo y Cabreado','Loja','costa',98745,'ecuador');
insert into Pedidos values(49,4,15,4,'23/04/2017','07/05/2017','06/05/2017','ninguno','Jasson','Enger Grow y Baticueba','Vinces','costa',98745,'ecuador');
insert into Pedidos values(50,5,15,5,'25/04/2017','07/05/2017','06/05/2017','ninguno','Natzu','Pichirilo y pasto','Palenque','costa',98745,'ecuador');
insert into Pedidos values(51,1,5,4,'17/04/2017','19/10/2017','06/12/2017','secretaria','Diana','Duran','Guayaquil','costa',13,'Ecuador');
insert into Pedidos values(52,2,2,2,'14/06/2017','10/10/2017','20/11/2017','recepsionista','Antonio','Montalvo','Babahoyo','costa',16,'Ecuador');
insert into Pedidos values(53,2,8,4,'02/03/2017','02/08/2017','07/09/2017','cajera','Alejandro','samanes1','Guayaquil','costa',11,'Ecuador');
insert into Pedidos values(54,6,6,5,'11/03/2017','12/04/2017','16/08/2017','gerente','Estefany','balsapamba','Bolivar','costa',12,'Ecuador');
insert into Pedidos values(55,9,5,1,'06/10/2017','21/08/2017','16/05/2017','director','Fernando','buena fe','Quito','sierra',5,'Ecuador');
insert into Proveedores values(1,'La fabril','ronald','secretario','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.fabril.com');
insert into Proveedores values(2,'ile','jardel','gerente','olmedo','guayaquil','costa',123,'ecuador',12345,'example','www.super.com');
insert into Proveedores values(3,'confiteca','jhosy','gerente','5junio','cuenca','sierra',123,'ecuador',12345,'example','www.confiteca.com');
insert into Proveedores values(4,'Maggi','ernesto','administrador','bahia','babahoyo','costa',123,'ecuador',12345,'example','www.mercado.com');
insert into Proveedores values(5,'Nestle','jose','encargado','centro','quito','sierra',123,'ecuador',12345,'example','www.favorita.com');
insert into Proveedores values(6,'Real','carlos','gerente','shopping','babahoyo','costa',123,'ecuador',12345,'example','www.vaquita.com');
insert into Proveedores values(7,'Vam Camps','ana','secretario','24mayo','azoguez','costa',123,'ecuador',12345,'example','www.lanueva.com');
insert into Proveedores values(8,'Isabel','lucia','administrador','bahia','quito','sierra',123,'ecuador',12345,'example','www.todofacil.com');
insert into Proveedores values(9,'Danec','adolfo','encargado','catedral','ambato','sierra',123,'ecuador',12345,'example','www.economica.com');
insert into Proveedores values(10,'Proesa','jostin','gerente','centro','guaranda','sierra',123,'ecuador',12345,'example','www.barata.com');
insert into Proveedores values(11,'Noel','noryi','gerente','malecon','babahoyo','costa',123,'ecuador',12345,'example','www.rapiditi.com');
insert into Proveedores values(12,'Dismero','coral','gerente','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.lorenzes.com');
insert into Proveedores values(13,'California','angel','gerente','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.oroan.com');
insert into Proveedores values(14,'Carli','sofia','gerente','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.axe.com');
insert into Proveedores values(15,'Sumesa','analucia','gerente','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.hp.com');
insert into Proveedores values(16,'ValDez','Lucas','Gerente de Ventas','Sucre y bolivar','Bogota','Sierra',1252,'Colombia',415566,'example','www.lmaestro.ec');
insert into Proveedores values(17,'Cris-Sal','Stalin','Gerente de Ventas','Ricauerte y loja','Quito','Costa',1452,'Ecuador',414585,'example','www.elanita.com');
insert into Proveedores values(18,'Facundo','Anita','Gerente de Ventas','Guku y cell 99','Guayas','Costa',5557,'Colombia',141452,'example','www.rosadosa.com');
insert into Proveedores values(19,'Coca Cola Companny','Joel','Gerente de Ventas','Guayaquil y quito','Vinces','Costa',5989,'Ecuador',125251,'example','www.alonatural.ec');
insert into Proveedores values(20,'Pronaca','Pedro','Gerente de Ventas','Bareiro y quito','Loja','Sierra',1112,'Ecuador',145854,'example','www.juanitosa.com');
INSERT INTO Proveedores VALUES(21,'La Universal','Belen','Gerente','Garcia Moreno y Barreiro','Babahoyo','Costa',002548,'Ecuador',0982547584,'example','www.dismeroSA.com');
INSERT INTO Proveedores VALUES(22,'Inalecsa','Gilda','Jefe','Balzar','Vinces','Costa',001457,'Ecuador',558474,'example','www.tia.com.ec');
insert into Proveedores values(23,'Zupan','jostin','gerente','centro','guaranda','sierra',123,'ecuador',12345,'example','www.barata.com');
insert into Proveedores values(24,'Don Vitorio','analucia','gerente','babahoyo','babahoyo','costa',123,'ecuador',12345,'example','www.DonVitorio.com');
INSERT INTO Proveedores VALUES(25,'unilever','Gilda','Jefe','Balzar','Vinces','Costa',001457,'Ecuador',558474,'example','www.unilever.com.ec');
insert into Proveedores values(26,'Kimberly-Clark Ecuador S.A','NORYI','GERENTE','MALECON','BABAHOYO','COSTA',123,'ECUADOR',12345,'EXAMPLE','WWW.Kimberly-ClarkI.COM');
insert into Categorias values(1,'Lacteos','Lacteos');
insert into Categorias values(2,'Snack','Snack');
insert into Categorias values(3,'panaderia','panaderia');
insert into Categorias values(4,'Aceites','Aceites');
insert into Categorias values(5,'Condimentos','Condimentos');
insert into Categorias values(6,'Carnes','Carnes');
insert into Categorias values(7,'Bebidas','Bebidas');
insert into Categorias values(8,'Golosinas','Golosinas');
insert into Categorias values(9,'DULCES','DULCES');
insert into Categorias values (10, 'Endulzantes', 'Endulzantes');
insert into Categorias values (11, 'Atun', 'Atun');
insert into Categorias values (12, 'Sardinas', 'Sardinas');
insert into Categorias values (13, 'Sal', 'Sal');
insert into Categorias values (14, 'Fideos', 'Fideos');
insert into Categorias values (15, 'Cafe', 'Cafe');
insert into Categorias values (16, 'Detergentes', 'Detergentes');
insert into Categorias values (17, 'Jabones', 'Jabones');
insert into Categorias values (18, 'Limpieza', 'Limpieza');
insert into Categorias values (19, 'Galletas', 'Galletas');
insert into Categorias values (20, 'Cigarrillos', 'Cigarrillos');
insert into Categorias values (21, 'Mantequillas', 'Mantequillas');
insert into Productos values(1,'Pan Integral',3,13,20,5,30,22,1,'NO');
insert into Productos values(2,'Pan Briollo',3,23,25,2,50,30,1,'NO');
insert into Productos values(3,'Papitas',2,14,22,7,45,10,1,'NO');
insert into Productos values(4,'La Vaquita',1,5,35,9,50,10,1,'SI');
insert into Productos values(5,'Spaguetti',14,15,26,8,60,20,1,'NO');
insert into Productos values(6,'Spaguetti',14,24,20,5,30,22,1,'SI');
insert into Productos values(7,'Galleta de Coco',19,5,25,2,50,30,1,'NO');
insert into Productos values(8,'Azucar Blanca',10,16,22,7,45,10,1,'SI');
insert into Productos values(9,'Galletas Taco Sal',19,5,35,9,50,10,1,'NO');
insert into Productos values(10,'Galletas de Amor',19,5,26,8,60,20,1,'SI');
insert into Productos values(11,'Detergente Deja',16,25,20,5,30,22,1,'NO');
insert into Productos values(12,'Detergente Ciclon',16,25,25,2,50,30,1,'NO');
insert into Productos values(13,'Pasta Dental Colgate',18,25,22,7,45,10,1,'NO');
insert into Productos values(14,'Pasta Dental Fortident',18,25,35,9,50,10,1,'SI');
insert into Productos values(15,'Papel Higenico Familia',18,25,26,8,60,20,1,'NO');
insert into Productos values(16,'Papel Higenico Flor',18,25,40,45,40,20,2,'SI');
insert into Productos values(17,'Papel Higenico Scott',18,25,20,35,20,15,1,'NO');
insert into Productos values(18,'Coca Cola',7,19,40,15,100,10,1,'NO');
insert into Productos values(19,'Sprite',7,19,80,10,20,10,1,'NO');
insert into Productos values(20,'Cafe Soluble Nescafe',15,1,40,25,20,10,1,'NO');
INSERT INTO Productos VALUES(21,'Cafe Soluble Buen Dia',15,1,25,1,30,25,5,'NO');
INSERT INTO Productos VALUES(22,'Maiz Dulce',5,18,100,3,150,90,5,'NO');
INSERT INTO Productos VALUES(23,'Maiz Precocido',5,18,30,5,0,25,25,'SI');
INSERT INTO Productos VALUES(24,'Menestra',5,18,25,2,30,10,5,'NO');
INSERT INTO Productos VALUES(25,'Aliño Completo',5,2,50,1,60,50,5,'NO');
insert into Productos values(26,'Comino Molido',5,2,45,87,20,10,1,'NO');
insert into Productos values(27,'Mayonesa',5,4,70,54,20,10,1,'NO');
insert into Productos values(28,'Mostaza',5,4,60,5,20,10,1,'NO');
insert into Productos values(29,'Salsa de Tomate',5,4,20,36,20,10,1,'NO');
insert into Productos values(30,'La Sazon',5,4,65,35,20,10,1,'NO');
insert into Productos values(31,'Achiote',4,1,20,5,30,22,1,'SI');
insert into Productos values(32,'Leche Entera',1,5,25,2,50,30,1,'SI');
insert into Productos values(33,'Atun Real',11,6,22,7,45,10,1,'SI');
insert into Productos values(34,'Atun Vam Camps',11,8,35,9,50,10,1,'SI');
insert into Productos values(35,'Aceite Favorita',4,1,26,8,60,20,1,'SI');
insert into Productos values (36,' Aceite Oro',4,9, 3, 150, 10, 3, 0, 'NO' );
insert into Productos values (37,'Aceite Cocinero',4,9, 3, 200, 10, 3, 0, 'NO' );
insert into Productos values (38,'Sardinas',12,6, 5, 250, 10, 3, 0, 'NO' );
insert into Productos values (39,'Cigarrillos Lider',20,10, 3, 150, 10, 3, 0, 'N0' );
insert into Productos values (40,'Cigarrillos Lark',20,10, 3, 250, 10, 3, 0, 'N0' );
INSERT INTO Productos VALUES (41,'Cigarrillos Marlboro',20,10,90,150,90,20,0,'SI');
INSERT INTO Productos VALUES (42,'Jabon Liquido Perla',17,1,50,68,50,10,0,'NO');
INSERT INTO Productos VALUES (43,'Jabon Perla',17,1,60,20,60,100,3,'NO');
INSERT INTO Productos VALUES (44,'Galletas Ducales',19,11,15,60,15,9,0,'SI');
INSERT INTO Productos VALUES (45,'Saltina Noel',19,11,8,137,8,2,0,'SI');
insert into Productos values(46,'Mantequilla Bonella',21,25,26,50,20,10,1,'NO');
insert into Productos values(47,'Mantequilla Girasol',21,25,30,75,20,10,1,'NO');
insert into Productos values(48,'Caramelos Leche y Miel',8,21,60,75,20,10,1,'NO');
insert into Productos values(49,'Menta Glacial',8,21,80,60,20,10,1,'NO');
insert into Productos values(50,'Panchitos',2,14,78,15,20,10,1,'NO');
insert into Productos values(51,'Inacake',2,22,70,25,75,25,2,'NO');
insert into Productos values(52,'Nuggets',6,20,35,40,15,40,3,'NO');
insert into Productos values(53,'Mr Pollo',6,20,40,15,10,10,1,'NO');
insert into Productos values(54,'Mr Chancho',6,20,45,15,28,18,4,'NO');
insert into Productos values(55,'tortolines',2,22,44,15,40,20,4,'NO');
INSERT INTO Productos VALUES (56,'Tostachos',2,22,60,20,60,100,3,'NO');
insert into Productos values(57,'Leche Nido',1,5,44,15,40,20,4,'NO');
insert into Detalle_Pedidos values(1,21,9,10,5);
insert into Detalle_Pedidos values(2,22,8,14,5);
insert into Detalle_Pedidos values(3,23,10,40,5);
insert into Detalle_Pedidos values(4,24,11,25,6);
insert into Detalle_Pedidos values(5,35,12,20,6);
insert into Detalle_Pedidos values(6,36,5,10,5);
insert into Detalle_Pedidos values(7,37,8,14,5);
insert into Detalle_Pedidos values(8,38,9,40,5);
insert into Detalle_Pedidos values(9,39,6,25,6);
insert into Detalle_Pedidos values(10,37,12,20,6);
insert into Detalle_Pedidos values(11,10,9,10,5);
insert into Detalle_Pedidos values(12,12,8,14,5);
insert into Detalle_Pedidos values(13,13,10,40,5);
insert into Detalle_Pedidos values(14,14,11,25,6);
insert into Detalle_Pedidos values(15,11,12,20,6);
insert into Detalle_Pedidos values(16,51,45,100,8);
insert into Detalle_Pedidos values(17,52,35,100,5);
insert into Detalle_Pedidos values(18,53,15,150,3);
insert into Detalle_Pedidos values(19,54,10,100,10);
insert into Detalle_Pedidos values(20,55,25,150,5);
INSERT INTO Detalle_Pedidos VALUES(21,42,2,25,10);
INSERT INTO Detalle_Pedidos VALUES(22,41,10,50,15);
INSERT INTO Detalle_Pedidos VALUES(23,45,3,30,12);
INSERT INTO Detalle_Pedidos VALUES(24,42,6,55,14);
INSERT INTO Detalle_Pedidos VALUES(25,43,4,15,5);
insert into Detalle_Pedidos values(26,20,10,245,5);
insert into Detalle_Pedidos values(27,21,20,432,25);
insert into Detalle_Pedidos values(28,22,35,150,23);
insert into Detalle_Pedidos values(29,23,43,100,2);
insert into Detalle_Pedidos values(30,24,35,150,23);
insert into Detalle_Pedidos values(31,16,2,20,5);
insert into Detalle_Pedidos values(32,17,2,24,5);
insert into Detalle_Pedidos values(33,18,3,100,5);
insert into Detalle_Pedidos values(34,19,4,100,6);
insert into Detalle_Pedidos values(35,20,1,50,6);
insert into Detalle_Pedidos values (36, 42, 150, 3, 5);
insert into Detalle_Pedidos values (37, 43, 250, 3, 2);
insert into Detalle_Pedidos values (38, 42, 100, 3, 10);
insert into Detalle_Pedidos values (39, 44, 300, 3, 8);
insert into Detalle_Pedidos values (40, 31, 110, 3, 20);
INSERT INTO Detalle_Pedidos VALUES(41,32,150,20,5);
INSERT INTO Detalle_Pedidos VALUES(42,35,68,10,2);
INSERT INTO Detalle_Pedidos VALUES(43,33,200,100,10);
INSERT INTO Detalle_Pedidos VALUES(44,21,60,9,3);
INSERT INTO Detalle_Pedidos VALUES(45,24,137,8,4);
insert into Detalle_Pedidos values(46,21,80,200,10);
insert into Detalle_Pedidos values(47,22,60,100,8);
insert into Detalle_Pedidos values(48,23,75,150,5);
insert into Detalle_Pedidos values(49,24,83,300,12);
insert into Detalle_Pedidos values(50,15,125,250,4);
insert into Detalle_Pedidos values(51,12,21,110,10);
insert into Detalle_Pedidos values(52,14,45,125,25);
insert into Detalle_Pedidos values(53,15,15,109,6);
insert into Detalle_Pedidos values(54,16,18,100,15);
insert into Detalle_Pedidos values(55,17,25,155,20);
--->Generando consultas de Selección
Select IdProducto, NombreProducto, PrecioUnidad
From Productos;