Untitled

USE SALES;

INSERT INTO SALESMAN VALUES (5000, 'Allan Yered', 'Soberanes');
INSERT INTO SALESMAN VALUES (5001, 'Luis Javier', 'Zamora');
INSERT INTO SALESMAN VALUES (5002, 'Luis Antonio', 'Zamudio');
INSERT INTO SALESMAN VALUES (5003, 'Hector Alfonso', 'Alvarez');
INSERT INTO SALESMAN VALUES (5004, 'Carlos Enrique', 'Antaño');
INSERT INTO SALESMAN VALUES (5005, 'Daniel', 'Navia');
INSERT INTO SALESMAN VALUES (5006, 'José Eduardo', 'Pulido');
INSERT INTO SALESMAN VALUES (5007, 'Omar Alejandro', 'Trejo');
INSERT INTO SALESMAN VALUES (5008, 'Brayan Jhony', 'Ramírez');
INSERT INTO SALESMAN VALUES (5009, 'Karla Paola', 'Romero');

INSERT INTO CUSTOMERS VALUES (3000, 'Bruno Antonio', 'Lopez');
INSERT INTO CUSTOMERS VALUES (3001, 'Ángel Fernando', 'Luna');
INSERT INTO CUSTOMERS VALUES (3002, 'Edgar Andrés', 'Mancilla');
INSERT INTO CUSTOMERS VALUES (3003, 'Irving Ricardo', 'Marín');
INSERT INTO CUSTOMERS VALUES (3004, 'Zaira Lilian', 'Martínez');
INSERT INTO CUSTOMERS VALUES (3005, 'Alan Emmanuel', 'Martínez');
INSERT INTO CUSTOMERS VALUES (3006, 'Hugo Rene', 'Membrillo');
INSERT INTO CUSTOMERS VALUES (3007, 'Ángel Daniel', 'Mora');
INSERT INTO CUSTOMERS VALUES (3008, 'Jesús Kevin', 'Ortíz');
INSERT INTO CUSTOMERS VALUES (3009, 'Salvador Adahir', 'Pardo');
INSERT INTO CUSTOMERS VALUES (3010, 'Brandon Miztli', 'Ramos');
INSERT INTO CUSTOMERS VALUES (3011, 'Yeshua Isaí', 'Ramos');
INSERT INTO CUSTOMERS VALUES (3012, 'Luis Ángel', 'Ríos');
INSERT INTO CUSTOMERS VALUES (3013, 'Francisco Javier', 'Rivera');
INSERT INTO CUSTOMERS VALUES (3014, 'Laura Alexia', 'Rodriguez');
INSERT INTO CUSTOMERS VALUES (3015, 'Javier', 'Rosas');
INSERT INTO CUSTOMERS VALUES (3016, 'Stefani', 'Ruiz');
INSERT INTO CUSTOMERS VALUES (3017, 'Raúl', 'Salgado');
INSERT INTO CUSTOMERS VALUES (3018, 'Brandon Moises', 'Sánchez');
INSERT INTO CUSTOMERS VALUES (3019, 'Othón', 'Sanchez de la Barquera');


insert into orders values (70000, 3508, '2021-01-27', 3007, 5008);
insert into orders values (70001, 9870, '2021-09-23', 3009, 5004);
insert into orders values (70002, 2189, '2021-12-19', 3001, 5009);
insert into orders values (70003, 8101, '2021-07-07', 3016, 5002);
insert into orders values (70004, 9926, '2021-04-10', 3010, 5001);
insert into orders values (70005, 6434, '2021-06-09', 3005, 5004);
insert into orders values (70006, 649, '2021-07-12', 3005, 5002);
insert into orders values (70007, 2975, '2021-06-12', 3000, 5001);
insert into orders values (70008, 1895, '2021-03-20', 3006, 5001);
insert into orders values (70009, 901, '2021-05-15', 3005, 5001);
insert into orders values (70010, 5480, '2021-02-10', 3017, 5002);
insert into orders values (70011, 4304, '2021-07-13', 3002, 5007);
insert into orders values (70012, 6502, '2021-07-21', 3014, 5008);
insert into orders values (70013, 4477, '2021-11-10', 3014, 5005);
insert into orders values (70014, 3428, '2021-09-08', 3008, 5001);
insert into orders values (70015, 1664, '2021-02-10', 3019, 5008);
insert into orders values (70016, 3061, '2021-04-25', 3017, 5006);
insert into orders values (70017, 506, '2021-04-25', 3015, 5001);
insert into orders values (70018, 4575, '2021-07-24', 3008, 5000);
insert into orders values (70019, 8729, '2021-10-12', 3013, 5000);
insert into orders values (70020, 1435, '2021-03-26', 3004, 5003);
insert into orders values (70021, 7663, '2021-05-03', 3009, 5000);
insert into orders values (70022, 2942, '2021-02-04', 3003, 5000);
insert into orders values (70023, 8115, '2021-09-18', 3006, 5006);
insert into orders values (70024, 3615, '2021-07-16', 3001, 5007);
insert into orders values (70025, 2727, '2021-01-12', 3018, 5008);
insert into orders values (70026, 7497, '2021-06-22', 3001, 5000);
insert into orders values (70027, 6162, '2021-04-15', 3013, 5003);
insert into orders values (70028, 2655, '2021-11-10', 3016, 5000);
insert into orders values (70029, 7961, '2021-01-12', 3009, 5006);
insert into orders values (70030, 4198, '2021-06-09', 3003, 5003);
insert into orders values (70031, 7077, '2021-07-01', 3010, 5006);
insert into orders values (70032, 8679, '2021-08-26', 3009, 5006);
insert into orders values (70033, 6803, '2021-05-30', 3005, 5003);
insert into orders values (70034, 2462, '2021-10-29', 3004, 5000);
insert into orders values (70035, 8334, '2021-02-24', 3009, 5007);
insert into orders values (70036, 9155, '2021-11-21', 3017, 5008);
insert into orders values (70037, 659, '2021-07-15', 3016, 5007);
insert into orders values (70038, 1243, '2021-12-08', 3015, 5001);
insert into orders values (70039, 4170, '2021-08-25', 3010, 5006);
insert into orders values (70040, 4160, '2021-10-20', 3015, 5002);
insert into orders values (70041, 9326, '2021-05-23', 3004, 5008);
insert into orders values (70042, 379, '2021-11-14', 3012, 5000);
insert into orders values (70043, 5945, '2021-08-19', 3001, 5001);
insert into orders values (70044, 3942, '2021-09-27', 3011, 5006);
insert into orders values (70045, 2846, '2021-06-06', 3018, 5000);
insert into orders values (70046, 6313, '2021-11-28', 3007, 5006);
insert into orders values (70047, 1083, '2021-10-15', 3007, 5006);
insert into orders values (70048, 3672, '2021-12-22', 3001, 5009);
insert into orders values (70049, 4930, '2021-11-28', 3002, 5003);
insert into orders values (70050, 1261, '2021-02-11', 3007, 5009);
insert into orders values (70051, 1434, '2021-07-12', 3012, 5003);
insert into orders values (70052, 3897, '2021-05-22', 3013, 5003);
insert into orders values (70053, 1579, '2021-08-10', 3005, 5007);
insert into orders values (70054, 727, '2021-08-17', 3019, 5001);
insert into orders values (70055, 9612, '2021-09-14', 3018, 5007);
insert into orders values (70056, 984, '2021-09-07', 3002, 5006);
insert into orders values (70057, 5081, '2021-01-26', 3014, 5003);
insert into orders values (70058, 5758, '2021-05-10', 3004, 5006);
insert into orders values (70059, 5142, '2021-01-02', 3017, 5006);
insert into orders values (70060, 199, '2021-08-24', 3013, 5005);
insert into orders values (70061, 7076, '2021-05-18', 3001, 5004);
insert into orders values (70062, 8036, '2021-01-24', 3009, 5001);
insert into orders values (70063, 5078, '2021-04-10', 3000, 5000);
insert into orders values (70064, 9212, '2021-10-05', 3001, 5009);
insert into orders values (70065, 3332, '2021-11-14', 3007, 5009);
insert into orders values (70066, 3623, '2021-12-11', 3007, 5007);
insert into orders values (70067, 5240, '2021-01-25', 3008, 5001);
insert into orders values (70068, 8064, '2021-08-26', 3015, 5006);
insert into orders values (70069, 7140, '2021-02-27', 3011, 5000);
insert into orders values (70070, 5976, '2021-08-01', 3006, 5002);
insert into orders values (70071, 1477, '2021-11-25', 3000, 5008);
insert into orders values (70072, 9573, '2021-03-22', 3008, 5002);
insert into orders values (70073, 2178, '2021-03-27', 3000, 5005);
insert into orders values (70074, 5033, '2021-01-05', 3005, 5006);
insert into orders values (70075, 589, '2021-05-28', 3006, 5005);
insert into orders values (70076, 1595, '2021-03-08', 3013, 5009);
insert into orders values (70077, 309, '2021-07-27', 3009, 5006);
insert into orders values (70078, 4266, '2021-01-03', 3006, 5007);
insert into orders values (70079, 6964, '2021-07-26', 3002, 5005);
insert into orders values (70080, 8264, '2021-09-05', 3004, 5004);
insert into orders values (70081, 5313, '2021-04-26', 3017, 5002);
insert into orders values (70082, 3071, '2021-12-16', 3001, 5006);
insert into orders values (70083, 2350, '2021-12-29', 3007, 5008);
insert into orders values (70084, 9677, '2021-04-28', 3013, 5003);
insert into orders values (70085, 5883, '2021-09-04', 3019, 5002);
insert into orders values (70086, 63, '2021-09-30', 3001, 5006);
insert into orders values (70087, 5249, '2021-12-17', 3019, 5009);
insert into orders values (70088, 196, '2021-07-01', 3009, 5007);
insert into orders values (70089, 1365, '2021-12-17', 3004, 5007);
insert into orders values (70090, 803, '2021-03-28', 3008, 5008);
insert into orders values (70091, 2391, '2021-04-07', 3002, 5005);
insert into orders values (70092, 3658, '2021-03-22', 3019, 5005);
insert into orders values (70093, 1927, '2021-11-18', 3011, 5009);
insert into orders values (70094, 1884, '2021-04-05', 3016, 5009);
insert into orders values (70095, 4450, '2021-07-30', 3005, 5003);
insert into orders values (70096, 9625, '2021-01-13', 3003, 5009);
insert into orders values (70097, 1183, '2021-11-29', 3019, 5001);
insert into orders values (70098, 1705, '2021-06-21', 3008, 5000);
insert into orders values (70099, 2243, '2021-05-16', 3000, 5005);
insert into orders values (70100, 9454, '2021-07-15', 3019, 5005);
insert into orders values (70101, 1871, '2021-08-24', 3015, 5007);
insert into orders values (70102, 2304, '2021-02-11', 3018, 5002);
insert into orders values (70103, 9449, '2021-03-31', 3019, 5008);
insert into orders values (70104, 2114, '2021-05-10', 3010, 5008);
insert into orders values (70105, 7577, '2021-10-08', 3011, 5005);
insert into orders values (70106, 3134, '2021-05-03', 3018, 5001);
insert into orders values (70107, 239, '2021-12-18', 3007, 5000);
insert into orders values (70108, 7731, '2021-12-06', 3008, 5009);
insert into orders values (70109, 2951, '2021-10-19', 3010, 5009);
insert into orders values (70110, 2894, '2021-08-27', 3013, 5001);
insert into orders values (70111, 9840, '2021-03-17', 3011, 5006);
insert into orders values (70112, 6443, '2021-07-16', 3018, 5006);
insert into orders values (70113, 9396, '2021-04-21', 3013, 5001);
insert into orders values (70114, 4275, '2021-03-19', 3013, 5008);
insert into orders values (70115, 3115, '2021-06-23', 3016, 5001);
insert into orders values (70116, 3061, '2021-12-13', 3011, 5006);
insert into orders values (70117, 6716, '2021-01-29', 3008, 5005);
insert into orders values (70118, 4127, '2021-12-26', 3013, 5002);
insert into orders values (70119, 333, '2021-03-30', 3011, 5004);
insert into orders values (70120, 1126, '2021-11-22', 3002, 5006);
insert into orders values (70121, 1055, '2021-03-05', 3003, 5009);
insert into orders values (70122, 2079, '2021-01-16', 3004, 5007);
insert into orders values (70123, 194, '2021-08-24', 3000, 5006);
insert into orders values (70124, 4871, '2021-06-05', 3004, 5006);
insert into orders values (70125, 5321, '2021-02-22', 3010, 5005);
insert into orders values (70126, 6270, '2021-03-31', 3010, 5002);
insert into orders values (70127, 5972, '2021-10-19', 3000, 5005);
insert into orders values (70128, 5144, '2021-05-27', 3011, 5009);
insert into orders values (70129, 6700, '2021-03-09', 3007, 5000);
insert into orders values (70130, 9182, '2021-01-04', 3009, 5007);
insert into orders values (70131, 9816, '2021-01-07', 3001, 5008);
insert into orders values (70132, 797, '2021-11-05', 3014, 5002);
insert into orders values (70133, 6452, '2021-08-02', 3006, 5006);
insert into orders values (70134, 9433, '2021-01-10', 3001, 5000);
insert into orders values (70135, 7671, '2021-04-17', 3008, 5007);
insert into orders values (70136, 654, '2021-09-28', 3015, 5003);
insert into orders values (70137, 9524, '2021-03-23', 3008, 5007);
insert into orders values (70138, 4660, '2021-04-07', 3007, 5007);
insert into orders values (70139, 9936, '2021-09-08', 3001, 5006);
insert into orders values (70140, 1886, '2021-10-06', 3012, 5003);
insert into orders values (70141, 8799, '2021-02-28', 3019, 5006);
insert into orders values (70142, 22, '2021-02-17', 3009, 5004);
insert into orders values (70143, 821, '2021-02-12', 3000, 5007);
insert into orders values (70144, 8239, '2021-04-28', 3014, 5009);
insert into orders values (70145, 6502, '2021-01-05', 3018, 5001);
insert into orders values (70146, 7122, '2021-08-26', 3014, 5003);
insert into orders values (70147, 904, '2021-09-20', 3008, 5004);
insert into orders values (70148, 579, '2021-08-09', 3018, 5000);
insert into orders values (70149, 9321, '2021-12-23', 3007, 5006);
insert into orders values (70150, 1301, '2021-08-12', 3010, 5007);
insert into orders values (70151, 4937, '2021-12-29', 3005, 5000);
insert into orders values (70152, 3005, '2021-11-05', 3002, 5006);
insert into orders values (70153, 291, '2021-11-02', 3014, 5003);
insert into orders values (70154, 42, '2021-11-16', 3007, 5008);
insert into orders values (70155, 3827, '2021-12-17', 3010, 5001);
insert into orders values (70156, 174, '2021-06-27', 3005, 5008);
insert into orders values (70157, 2307, '2021-11-07', 3016, 5009);
insert into orders values (70158, 9197, '2021-07-27', 3009, 5006);
insert into orders values (70159, 2121, '2021-11-11', 3011, 5007);
insert into orders values (70160, 2482, '2021-09-22', 3015, 5002);
insert into orders values (70161, 1515, '2021-08-03', 3016, 5009);
insert into orders values (70162, 221, '2021-03-03', 3006, 5002);
insert into orders values (70163, 9675, '2021-07-04', 3019, 5008);
insert into orders values (70164, 6441, '2021-04-04', 3004, 5000);
insert into orders values (70165, 1395, '2021-12-19', 3014, 5004);
insert into orders values (70166, 4546, '2021-02-03', 3000, 5005);
insert into orders values (70167, 8051, '2021-04-22', 3013, 5003);
insert into orders values (70168, 2978, '2021-07-04', 3013, 5001);
insert into orders values (70169, 7421, '2021-01-09', 3000, 5000);
insert into orders values (70170, 9749, '2021-04-25', 3018, 5000);
insert into orders values (70171, 4017, '2021-09-25', 3011, 5001);
insert into orders values (70172, 888, '2021-08-27', 3011, 5004);
insert into orders values (70173, 5491, '2021-07-26', 3013, 5009);
insert into orders values (70174, 8190, '2021-05-27', 3009, 5005);
insert into orders values (70175, 5210, '2021-07-22', 3016, 5000);
insert into orders values (70176, 5327, '2021-10-31', 3004, 5007);
insert into orders values (70177, 4675, '2021-04-11', 3008, 5005);
insert into orders values (70178, 8598, '2021-10-24', 3016, 5009);
insert into orders values (70179, 2681, '2021-08-08', 3006, 5006);
insert into orders values (70180, 1977, '2021-08-04', 3005, 5006);
insert into orders values (70181, 1282, '2021-03-07', 3006, 5000);
insert into orders values (70182, 4020, '2021-07-27', 3013, 5002);
insert into orders values (70183, 2404, '2021-03-23', 3014, 5007);
insert into orders values (70184, 2292, '2021-02-06', 3014, 5009);
insert into orders values (70185, 293, '2021-08-22', 3008, 5001);
insert into orders values (70186, 958, '2021-04-18', 3006, 5001);
insert into orders values (70187, 6336, '2021-02-06', 3010, 5001);
insert into orders values (70188, 385, '2021-09-02', 3009, 5005);
insert into orders values (70189, 6406, '2021-01-31', 3007, 5008);
insert into orders values (70190, 5557, '2021-08-20', 3004, 5003);
insert into orders values (70191, 3684, '2021-09-29', 3010, 5002);
insert into orders values (70192, 1504, '2021-12-30', 3002, 5009);
insert into orders values (70193, 5209, '2021-11-22', 3011, 5003);
insert into orders values (70194, 1026, '2021-03-16', 3000, 5002);
insert into orders values (70195, 8459, '2021-03-12', 3010, 5003);
insert into orders values (70196, 9800, '2021-08-04', 3008, 5008);
insert into orders values (70197, 5831, '2021-01-31', 3004, 5009);
insert into orders values (70198, 8572, '2021-11-27', 3011, 5009);