--vehicle data
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (1, '7BWV747', 12000, 'Mazda', '929', '1ZVBP8JS8B5624408');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (2, '6WJA118',23000, 'GMC', 'Savana 1500', '3VWKP7AJXDM563299');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (3, '7AKC746',34000, 'Nissan', 'Pathfinder', '3D73Y4EL7AG309256');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (4, '6WJA118',45000, 'Chrysler', 'Voyager', 'WBANB33515C895056');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (5, '7AKC746',56000, 'Dodge', 'Viper', 'JN1CV6AP0BM984150');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (6, '7BRW365',67000, 'Jeep', 'Wrangler', '3FAHP0DC2BR629741');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (7, '7BWV747',78000, 'Hyundai', 'Elantra', 'YV4902BZ4B1936423');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (8, '6WJA118',89000, 'Volvo', 'S60', 'SCFFDAAE3CG903450');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (9, '7AFY475',98000, 'Dodge', 'Ram Van 3500', '1D4PT7GX0BW942084');
insert into Vehicle (VehicleID, PlateNumber,LicenseNumber, Make, Model, VIN) values (10, '7AYF890',10000, 'GMC', 'Suburban 1500', 'WUAGL78E86A467199');

--GasReceipt
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (1, 78000, 'Hayes', 'Bakersfield', 'CA', 11111, '$47.26', '11/29/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (2, 56000, 'Waubesa', 'Bakersfield', 'CA', 11116, '$129.21', '11/5/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (3, 67000, 'Gerald', 'Bakersfield', 'CA', 11121, '$33.30', '10/27/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (4, 67000, 'Glendale', 'Bakersfield', 'CA', 11126, '$50.31', '11/30/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (5, 34000, 'Macpherson', 'Bakersfield', 'CA', 11131, '$44.57', '10/2/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (6, 34000, 'Lindbergh', 'Bakersfield', 'CA', 11136, '$90.22', '3/23/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (7, 78000, 'Acker', 'Bakersfield', 'CA', 11141, '$93.01', '8/29/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (8, 34000, 'Mesta', 'Bakersfield', 'CA', 11146, '$54.81', '3/6/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (9, 45000, 'Charing Cross', 'Bakersfield', 'CA', 11111, '$100.16', '10/26/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (10, 34000, 'Dunning', 'Bakersfield', 'CA', 11116, '$129.55', '8/24/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (11, 98000, 'Bashford', 'Bakersfield', 'CA', 11121, '$34.03', '4/23/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (12, 12000, 'Fuller', 'Bakersfield', 'CA', 11126, '$98.30', '11/2/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (13, 89000, 'Mayer', 'Bakersfield', 'CA', 11131, '$43.84', '2/13/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (14, 45000, 'Maple Wood', 'Bakersfield', 'CA', 11136, '$113.26', '3/7/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (15, 56000, 'Moose', 'Bakersfield', 'CA', 11141, '$105.00', '2/9/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (16, 23000, 'Dahle', 'Bakersfield', 'CA', 11146, '$92.30', '3/30/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (17, 67000, 'Crescent Oaks', 'Bakersfield', 'CA', 11111, '$91.59', '1/16/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (18, 89000, 'Grayhawk', 'Bakersfield', 'CA', 11116, '$89.63', '1/11/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (19, 12000, 'Oriole', 'Bakersfield', 'CA', 11121, '$118.32', '2/2/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (20, 78000, 'Nevada', 'Bakersfield', 'CA', 11126, '$40.33', '1/4/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (21, 78000, 'Holmberg', 'Bakersfield', 'CA', 11131, '$98.22', '1/26/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (22, 78000, 'Pierstorff', 'Bakersfield', 'CA', 11136, '$67.42', '8/16/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (23, 89000, '6th', 'Bakersfield', 'CA', 11141, '$44.52', '3/1/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (24, 34000, 'Portage', 'Bakersfield', 'CA', 11146, '$75.23', '10/17/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (25, 78000, 'Spohn', 'Bakersfield', 'CA', 11111, '$26.41', '4/29/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (26, 23000, 'Buell', 'Bakersfield', 'CA', 11116, '$120.01', '12/13/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (27, 12000, 'Annamark', 'Bakersfield', 'CA', 11121, '$98.83', '2/3/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (28, 56000, 'Jenna', 'Bakersfield', 'CA', 11126, '$65.04', '8/8/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (29, 78000, 'Goodland', 'Bakersfield', 'CA', 11131, '$75.03', '5/26/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (30, 34000, 'Oak', 'Bakersfield', 'CA', 11136, '$29.40', '10/29/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (31, 12000, 'Dovetail', 'Bakersfield', 'CA', 11141, '$99.86', '2/24/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (32, 89000, 'Amoth', 'Bakersfield', 'CA', 11146, '$96.12', '6/15/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (33, 45000, 'Warbler', 'Bakersfield', 'CA', 11111, '$135.90', '12/13/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (34, 89000, 'Quincy', 'Bakersfield', 'CA', 11116, '$24.61', '9/11/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (35, 10000, 'Blackbird', 'Bakersfield', 'CA', 11121, '$24.80', '4/25/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (36, 12000, 'Merry', 'Bakersfield', 'CA', 11126, '$77.21', '4/28/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (37, 78000, 'Parkside', 'Bakersfield', 'CA', 11131, '$108.05', '2/1/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (38, 34000, 'Lake View', 'Bakersfield', 'CA', 11136, '$80.20', '1/28/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (39, 12000, 'Hazelcrest', 'Bakersfield', 'CA', 11141, '$96.73', '1/18/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (40, 12000, 'Northland', 'Bakersfield', 'CA', 11146, '$60.86', '12/2/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (41, 67000, 'Tomscot', 'Bakersfield', 'CA', 11111, '$104.01', '10/17/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (42, 56000, 'Ramsey', 'Bakersfield', 'CA', 11116, '$143.97', '11/7/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (43, 89000, 'Shasta', 'Bakersfield', 'CA', 11121, '$78.02', '1/16/2019');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (44, 34000, 'Ilene', 'Bakersfield', 'CA', 11126, '$41.45', '9/6/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (45, 56000, 'Schmedeman', 'Bakersfield', 'CA', 11131, '$77.10', '7/10/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (46, 67000, 'Crescent Oaks', 'Bakersfield', 'CA', 11136, '$110.79', '7/23/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (47, 98000, 'Goodland', 'Bakersfield', 'CA', 11141, '$56.89', '8/19/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (48, 67000, 'Onsgard', 'Bakersfield', 'CA', 11146, '$137.30', '11/8/2018');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (49, 45000, 'Luster', 'Bakersfield', 'CA', 11111, '$114.06', '8/27/2017');
insert into GasReceipt (ReceiptID, LicenseNumber, StreetName, City, State, Zip, TotalPrice, DateCreated) values (50, 12000, 'Lien', 'Bakersfield', 'CA', 11116, '$106.88', '6/11/2017');
--Invoice data
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (1, 9, '12/31/2018', '8:03 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (2, 2, '1/12/2018', '5:11 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (3, 6, '7/21/2018', '3:41 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (4, 8, '9/19/2017', '6:57 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (5, 9, '5/15/2018', '1:00 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (6, 6, '3/5/2019', '11:22 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (7, 5, '9/19/2017', '5:52 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (8, 4, '2/7/2018', '11:38 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (9, 1, '10/17/2017', '12:03 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (10, 5, '11/9/2018', '8:32 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (11, 6, '8/26/2017', '8:47 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (12, 8, '1/21/2018', '11:08 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (13, 10, '3/13/2018', '8:17 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (14, 7, '5/18/2018', '5:24 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (15, 1, '5/23/2017', '10:46 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (16, 9, '11/29/2017', '6:30 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (17, 7, '12/12/2018', '1:37 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (18, 1, '2/5/2018', '2:19 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (19, 9, '12/25/2017', '7:03 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (20, 3, '5/13/2018', '10:41 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (21, 5, '1/28/2018', '7:50 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (22, 4, '8/29/2018', '7:06 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (23, 5, '4/19/2017', '8:15 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (24, 2, '12/20/2017', '5:01 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (25, 1, '1/26/2019', '10:08 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (26, 10, '6/12/2017', '2:55 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (27, 2, '12/3/2018', '8:44 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (28, 3, '2/12/2018', '12:59 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (29, 10, '7/14/2017', '8:30 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (30, 9, '4/27/2018', '10:34 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (31, 8, '10/12/2017', '9:18 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (32, 8, '6/7/2018', '8:48 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (33, 3, '3/19/2019', '11:25 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (34, 7, '5/24/2017', '1:33 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (35, 1, '2/5/2018', '11:25 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (36, 6, '11/24/2018', '5:40 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (37, 8, '9/11/2017', '8:29 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (38, 8, '6/13/2017', '6:15 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (39, 6, '8/17/2017', '6:15 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (40, 8, '11/14/2018', '8:57 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (41, 2, '5/23/2018', '5:14 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (42, 10, '9/8/2017', '12:06 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (43, 4, '2/22/2019', '2:46 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (44, 9, '9/5/2018', '3:00 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (45, 1, '2/17/2018', '12:36 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (46, 5, '9/7/2017', '3:52 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (47, 5, '12/13/2018', '6:21 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (48, 10, '1/13/2019', '7:39 AM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (49, 7, '4/3/2017', '1:23 PM');
insert into Invoice (InvoiceID, MachineID, DateCreated, TimeCreated) values (50, 4, '8/1/2018', '9:15 AM');

-- --ItemsSold
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 8, 5, '$4.84');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 6, 11, '$0.62');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 6, 5, '$3.22');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 6, 19, '$2.00');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 10, 9, '$3.82');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 10, 20, '$4.19');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 2, 13, '$5.93');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 2, 1, '$3.56');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 4, 14, '$4.08');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 5, 14, '$4.60');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 2, 18, '$0.38');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 6, 8, '$4.92');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 2, 15, '$1.37');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 6, 18, '$0.20');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 8, 5, '$3.59');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 10, 16, '$4.71');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 1, 3, '$0.95');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 3, 10, '$1.54');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 5, 8, '$3.31');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 10, 6, '$5.49');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 7, 18, '$3.81');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 6, 11, '$4.05');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 2, 6, '$1.79');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 3, 8, '$3.27');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 7, 16, '$0.24');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 5, 19, '$3.95');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 8, 19, '$4.31');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 8, 4, '$5.51');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 10, 6, '$5.41');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 1, 3, '$1.29');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 3, 2, '$5.66');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 7, 4, '$5.54');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 3, 8, '$4.54');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 4, 10, '$0.39');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 10, 1, '$3.66');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 8, 16, '$2.30');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 4, 10, '$0.87');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 2, 17, '$1.44');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 9, 17, '$3.79');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 9, 17, '$4.59');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 7, 16, '$3.76');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 8, 9, '$1.17');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 9, 11, '$3.21');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 8, 18, '$5.79');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 2, 8, '$1.98');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 4, 16, '$4.70');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 10, 10, '$5.34');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 5, 18, '$5.13');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 1, 8, '$5.16');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 1, 5, '$0.61');

--Supplier
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (1, 'Lajo', '213-882-2592', 'Mosinee', 'Los Angeles', 'CA', 11111);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (2, 'Cogidoo', '209-341-5236', 'Daystar', 'Stockton', 'CA', 11112);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (3, 'Quaxo', '818-647-8909', 'Nevada', 'North Hollywood', 'CA', 11113);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (4, 'Photospace', '559-779-8191', 'Fulton', 'Visalia', 'CA', 11114);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (5, 'Youspan', '818-544-7711', 'Walton', 'North Hollywood', 'CA', 11115);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (6, 'Oyope', '310-529-6251', 'Parkside', 'Long Beach', 'CA', 11116);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (7, 'Skidoo', '818-175-5739', 'Packers', 'Glendale', 'CA', 11117);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (8, 'Skimia', '858-574-6504', 'Dexter', 'San Diego', 'CA', 11118);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (9, 'Kwinu', '213-538-2484', 'Chive', 'Los Angeles', 'CA', 11119);
insert into Supplier (SupplierID, Name, Phone, StreetName, City, State, Zip) values (10, 'Centizu', '559-270-0717', 'Maryland', 'Visalia', 'CA', 11120);

--ItemType
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (1, 'Pepsi', '$3.20');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (2, 'Sprite', '$1.35');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (3, 'Squirt', '$2.90');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (4, 'Coke', '$2.56');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (5, 'Diet Pepsi', '$3.29');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (6, 'DIet Coke', '$1.03');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (7, 'Fanta', '$1.04');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (8, 'Powerade', '$1.78');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (9, 'Minute Maid', '$3.94');
insert into itemType (ItemTypeID, ItemTypeName, MSRP ) values (10, 'Crush', '$2.41');

--Warehouse
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (1, '123-45-6789', 10000, 'Doe Crossing', 'Bakersfield', 'CA', 11111);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (2, '987-65-4321', 50000, 'Dayton', 'Bakersfield', 'CA', 11112);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (3, '987-65-4321', 50000, 'Hanover', 'Bakersfield', 'CA', 11113);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (4, '987-65-4321', 50000, 'Oxford', 'Bakersfield', 'CA', 11114);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (5, '987-65-4321', 50000, 'Glacier Hill', 'Bakersfield', 'CA', 11115);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (6, '123-45-6789', 50000, 'Redwing', 'Bakersfield', 'CA', 11116);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (7, '123-45-6789', 50000, 'Onsgard', 'Bakersfield', 'CA', 11117);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (8, '123-45-6789', 25000, 'Pawling', 'Bakersfield', 'CA', 11118);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (9, '123-45-6789', 10000, 'Columbus', 'Bakersfield', 'CA', 11119);
insert into Warehouse (WarehouseID, SSN, Capacity , StreetName, City, State, Zip) values (10, '987-65-4321', 20000, 'Towne', 'Bakersfield', 'CA', 11120);

--WarehouseReceives
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (2, 10, '6:51 AM', '1/10/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (5, 1, '8:22 AM', '6/9/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 10, '9:38 PM', '5/28/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (1, 2, '7:19 AM', '9/27/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (9, 8, '1:57 PM', '2/23/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (9, 10, '6:56 PM', '9/1/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (7, 8, '2:52 PM', '1/17/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 7, '12:10 PM', '2/11/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (2, 7, '12:57 PM', '2/17/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 1, '2:17 PM', '6/1/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 10, '4:41 PM', '2/24/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (2, 2, '2:06 AM', '7/14/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 9, '11:09 AM', '11/24/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (8, 7, '4:43 PM', '5/8/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 5, '11:23 PM', '4/3/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 2, '1:56 PM', '1/14/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (2, 3, '12:23 AM', '6/26/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 5, '1:43 PM', '11/9/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (7, 7, '12:12 PM', '9/14/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (9, 10, '3:06 PM', '3/13/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 8, '4:38 PM', '5/1/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 4, '2:25 PM', '2/23/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 6, '4:35 AM', '8/2/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 6, '10:35 PM', '9/7/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 1, '10:50 PM', '10/2/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (5, 4, '7:52 PM', '12/14/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (5, 9, '9:04 PM', '5/14/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 8, '5:07 AM', '5/26/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 1, '1:23 AM', '7/30/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (7, 1, '10:36 AM', '7/29/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 2, '10:33 PM', '5/8/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 1, '1:44 PM', '2/16/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 7, '7:53 AM', '5/22/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (4, 7, '12:14 AM', '12/19/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 4, '9:06 AM', '9/6/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (6, 5, '6:20 AM', '8/12/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (1, 3, '2:00 PM', '12/7/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (4, 9, '11:18 PM', '12/2/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (1, 4, '7:47 PM', '2/11/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (9, 6, '5:41 AM', '9/20/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (8, 3, '9:00 AM', '10/6/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (2, 3, '7:39 AM', '2/25/2019');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (8, 6, '4:07 AM', '9/6/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (5, 4, '4:26 PM', '3/26/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (5, 7, '11:52 AM', '3/13/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (3, 2, '9:09 PM', '10/30/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (7, 8, '10:23 PM', '9/1/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (10, 5, '3:07 AM', '10/13/2017');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (1, 8, '12:46 PM', '9/10/2018');
insert into WarehouseReceives (OrderID, WarehouseID, TimeRec, DateRec) values (9, 8, '3:28 AM', '8/20/2017');


--OrdersFrom
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 8, '10/18/2018', '2:45 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (2, 8, '6/18/2018', '5:59 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 7, '3/14/2018', '5:18 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 6, '9/22/2017', '1:34 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 9, '8/14/2017', '5:30 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 4, '5/17/2018', '1:14 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 2, '2/20/2019', '6:57 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (9, 10, '1/5/2018', '5:59 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 4, '9/19/2018', '5:17 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (10, 1, '7/27/2018', '11:17 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (2, 7, '12/23/2017', '3:33 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (4, 5, '7/9/2018', '4:55 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (7, 2, '10/23/2018', '12:26 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 1, '11/14/2018', '11:06 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 10, '4/4/2018', '2:39 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (7, 3, '1/1/2018', '5:58 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 2, '12/9/2018', '5:47 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 1, '6/17/2018', '6:42 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 6, '11/17/2017', '3:57 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 3, '7/26/2018', '7:39 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 8, '9/21/2017', '8:48 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (2, 5, '11/30/2018', '2:18 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 6, '5/13/2018', '3:24 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 1, '11/6/2018', '5:35 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 1, '7/30/2018', '7:36 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (5, 3, '12/15/2018', '2:45 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (10, 9, '1/11/2019', '8:57 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 2, '5/30/2017', '10:27 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (4, 5, '7/5/2018', '8:40 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 1, '11/26/2018', '5:02 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 3, '8/30/2018', '9:57 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 3, '12/25/2017', '10:21 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (10, 3, '1/14/2019', '11:44 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 3, '8/18/2018', '2:20 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 8, '10/23/2018', '11:43 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 5, '1/21/2019', '4:25 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 6, '7/25/2018', '2:22 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (10, 3, '12/30/2018', '10:32 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 10, '12/18/2018', '11:10 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 7, '11/20/2017', '3:19 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (10, 4, '6/1/2017', '1:01 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 3, '5/7/2017', '6:28 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 9, '4/20/2017', '1:35 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (8, 4, '2/26/2018', '10:17 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 3, '4/8/2018', '9:39 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (2, 9, '2/1/2018', '9:37 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (9, 8, '6/6/2017', '4:01 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (3, 7, '4/23/2017', '2:16 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (6, 10, '5/10/2018', '7:14 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 5, '12/5/2018', '6:31 PM');

--PlacesOrder
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 6, '5:20 AM', '11/18/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (3, 8, '10:22 AM', '8/12/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (3, 2, '1:03 AM', '4/2/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (7, 2, '2:02 PM', '2/18/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 10, '7:56 AM', '11/28/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 1, '8:29 AM', '8/7/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 3, '11:49 PM', '10/26/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (5, 8, '1:17 AM', '10/24/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 2, '11:38 AM', '10/24/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (1, 10, '5:10 PM', '10/13/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (7, 8, '5:59 AM', '10/19/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 5, '9:52 AM', '7/28/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 1, '3:40 AM', '2/12/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 8, '8:16 AM', '4/15/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (9, 2, '6:09 AM', '12/9/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (5, 9, '7:50 AM', '12/15/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (1, 8, '3:38 PM', '2/18/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 1, '5:25 PM', '5/20/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 8, '3:53 AM', '4/13/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (1, 6, '7:53 AM', '1/20/2019');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 10, '9:08 AM', '8/11/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 6, '8:09 AM', '7/19/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (3, 2, '5:51 AM', '4/15/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (9, 10, '8:17 PM', '3/23/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 10, '4:44 AM', '5/31/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (9, 10, '12:53 AM', '10/6/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (4, 7, '3:49 AM', '6/14/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (10, 8, '2:18 AM', '11/25/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 8, '8:47 AM', '8/21/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 5, '10:31 AM', '7/19/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (9, 2, '7:57 PM', '5/6/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (7, 6, '11:18 AM', '10/22/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (5, 2, '7:04 AM', '1/31/2019');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (7, 5, '10:22 PM', '1/19/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (7, 5, '6:00 PM', '6/5/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (9, 3, '9:13 PM', '4/7/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (10, 9, '9:41 PM', '7/25/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 2, '1:16 PM', '3/14/2019');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (4, 5, '2:58 AM', '3/21/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 6, '5:05 AM', '3/3/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 10, '10:28 AM', '2/10/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (4, 3, '6:02 AM', '3/30/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (4, 10, '12:34 AM', '8/8/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (6, 7, '1:35 PM', '2/13/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (4, 4, '1:06 PM', '7/15/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 6, '3:34 AM', '10/28/2018');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (8, 10, '11:15 PM', '8/27/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (5, 7, '10:08 AM', '10/28/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 5, '4:12 AM', '8/5/2017');
insert into PlacesOrder (OrderID, BadgeNumber, TimePlaced, DatePlaced) values (2, 7, '7:12 AM', '10/24/2017');

--WarehouseHas
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 9, '198', '$1.12');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 2, '77', '$1.59');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 8, '58', '$2.23');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 3, '132', '$1.65');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 5, '156', '$3.35');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 3, '100', '$2.72');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 5, '78', '$3.60');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 5, '159', '$2.23');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 6, '119', '$2.66');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 6, '98', '$2.83');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 10, '62', '$2.68');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 7, '155', '$2.84');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 5, '8', '$2.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 4, '126', '$1.05');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 8, '200', '$3.29');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 10, '95', '$2.80');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 2, '21', '$1.96');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 2, '49', '$2.83');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 9, '25', '$1.63');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 9, '161', '$1.18');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 4, '141', '$1.00');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 4, '71', '$3.42');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 10, '22', '$3.41');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 8, '101', '$2.32');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 1, '111', '$3.10');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 3, '138', '$3.20');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 4, '71', '$1.49');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 9, '91', '$2.54');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 3, '68', '$2.62');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 4, '68', '$1.89');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 6, '41', '$1.41');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 10, '69', '$1.25');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 3, '115', '$3.90');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 1, '73', '$3.92');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 3, '118', '$1.99');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 4, '176', '$3.42');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 9, '62', '$2.18');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 5, '178', '$3.02');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 9, '137', '$3.36');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 1, '140', '$3.25');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 5, '96', '$1.14');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 5, '155', '$2.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 8, '40', '$1.40');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 9, '61', '$2.33');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 6, '16  7', '$2.26');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 9, '57', '$1.78');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 10, '125', '$2.29');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 10, '179', '$1.52');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 5, '47', '$3.20');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '60', '$2.18');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 10, '176', '$3.84');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 7, '77', '$2.23');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 6, '82', '$3.85');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 2, '35', '$1.43');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 4, '109', '$1.00');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 5, '158', '$1.91');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 6, '91', '$1.65');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 9, '161', '$3.01');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 1, '138', '$3.23');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 9, '18', '$2.42');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 2, '101', '$1.87');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 2, '102', '$3.39');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 1, '171', '$3.38');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 3, '26', '$2.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 1, '112', '$3.84');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 10, '134', '$1.79');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 3, '13', '$1.75');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 10, '199', '$1.77');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 8, '5', '$3.73');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 6, '154', '$3.72');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 7, '77', '$1.75');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 8, '139', '$3.10');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 2, '87', '$2.86');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '74', '$1.29');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 9, '67', '$2.54');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 1, '149', '$2.47');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 10, '70', '$2.68');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 8, '95', '$1.25');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 3, '147', '$3.87');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 4, '11', '$1.88');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 10, '125', '$1.28');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 1, '22', '$1.89');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 1, '166', '$3.78');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 5, '136', '$2.95');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 5, '89', '$1.55');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 3, '180', '$1.40');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 9, '60', '$1.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 2, '4', '$2.46');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 2, '116', '$1.49');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 1, '130', '$2.86');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '108', '$1.48');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (4, 8, '101', '$2.08');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '143', '$3.86');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 9, '29', '$2.65');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 5, '74', '$1.26');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 7, '32', '$3.70');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 8, '42', '$3.80');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 3, '81', '$3.09');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 10, '113', '$2.05');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 10, '34', '$3.79');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 8, '117', '$1.98');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 8, '73', '$2.93');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 9, '128', '$1.77');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 8, '110', '$3.16');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 8, '192', '$2.46');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 2, '161', '$2.18');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 1, '75', '$3.00');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 5, '3', '$3.66');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 3, '44', '$1.80');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 7, '129', '$3.61');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 2, '195', '$2.16');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 4, '17', '$2.37');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 2, '39', '$2.17');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 10, '168', '$2.44');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 6, '89', '$3.55');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 3, '56', '$1.86');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '70', '$1.10');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 1, '71', '$1.88');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 4, '84', '$3.96');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 8, '30', '$1.96');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 8, '12', '$3.41');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 2, '114', '$2.88');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 5, '84', '$3.53');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 9, '123', '$3.30');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 9, '65', '$3.38');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 10, '129', '$2.18');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 1, '172', '$3.17');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 7, '49', '$3.61');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (2, 5, '179', '$4.00');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 2, '125', '$2.21');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 10, '64', '$3.92');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 5, '65', '$1.71');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 8, '155', '$2.52');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 9, '82', '$2.50');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 1, '171', '$3.65');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 10, '72', '$2.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 7, '73', '$1.91');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (8, 5, '196', '$3.08');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 5, '105', '$3.57');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 9, '2', '$2.91');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (3, 8, '134', '$2.72');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 8, '174', '$3.31');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (6, 6, '91', '$1.76');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 3, '98', '$1.92');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (9, 10, '150', '$3.15');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 6, '107', '$3.77');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (10, 4, '57', '$1.78');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (5, 10, '110', '$2.57');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (7, 8, '140', '$2.10');
insert into WarehouseHas (WarehouseID, ItemTypeID, NumItemType, ItemTypePrice) values (1, 6, '161', '$1.10');

--ItemsSold
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 19, '101', '$0.20');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 24, '52', '$8.47');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 15, '103', '$2.97');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 22, '23', '$8.57');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 22, '56', '$1.48');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 16, '114', '$4.30');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 14, '164', '$4.98');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 3, '124', '$3.80');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 16, '110', '$6.64');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 40, '44', '$4.64');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 24, '138', '$3.12');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 42, '150', '$9.51');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 33, '84', '$5.25');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 29, '127', '$6.35');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 47, '76', '$8.56');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 22, '109', '$5.20');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 10, '131', '$2.62');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (10, 21, '78', '$3.86');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 11, '4', '$0.08');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 48, '108', '$0.17');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 35, '99', '$1.90');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (1, 37, '57', '$9.11');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 18, '3', '$2.36');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 23, '60', '$6.55');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 48, '105', '$9.21');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 31, '123', '$4.18');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 29, '190', '$3.63');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 31, '59', '$8.60');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 32, '197', '$0.23');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 37, '13', '$0.87');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 3, '169', '$0.08');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (9, 31, '67', '$8.69');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 14, '126', '$4.63');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 35, '2', '$4.04');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 42, '191', '$6.51');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 30, '155', '$6.35');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 10, '65', '$2.60');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 30, '77', '$0.75');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 12, '108', '$3.23');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 2, '41', '$3.19');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 1, '105', '$2.99');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 20, '95', '$7.32');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (2, 35, '176', '$8.62');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (6, 16, '173', '$1.52');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (5, 12, '166', '$9.98');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 5, '197', '$6.42');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (3, 31, '77', '$0.62');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (7, 46, '91', '$6.32');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (4, 42, '5', '$4.49');
insert into ItemsSold (ItemTypeID, InvoiceID, NumSold, PriceSold) values (8, 49, '123', '$3.15');
-- Employee
insert into Employee (EmployeeID, FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (1,'Nadiya', 'Sleightholme', '858-121-5457', 'Dispatcher', '$87018.92', '12/13/2012', '1842 Ridge Oak Hill', 'San Diego', 'CA', '92105', 12000, 1, 'nsleightholme0@bbc.co.uk', '444-87-3220');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (2,'Giulia', 'McSorley', '916-134-2215', 'Driver', '$77363.26', '3/24/2007', '532 Washington Parkway', 'Sacramento', 'CA', '94297', 23000, 2, 'gmcsorley1@go.com', '221-52-7822');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (3,'Pascal', 'Radbourne', '415-583-1366', 'Driver', '$68600.87', '7/20/2008', '46 Sommers Point', 'San Francisco', 'CA', '94159', 34000, 3, 'pradbourne2@tiny.cc', '384-48-7106');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (4,'Brittani', 'Tuxsell', '714-645-1073', 'Dispatcher', '$18727.07', '5/6/2007', '80 Green Court', 'Orange', 'CA', '92862', 45000, 4, 'btuxsell3@alibaba.com', '588-41-0157');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (5,'Alexis', 'Treece', '661-620-2794', 'Driver', '$18186.96', '2/20/2014', '0490 Nancy Alley', 'Bakersfield', 'CA', '93399', 56000, 5, 'atreece4@baidu.com', '241-07-2426');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (6,'Jobey', 'Shemmans', '909-729-9475', 'Driver', '$30795.37', '5/24/2004', '1996 Erie Court', 'San Bernardino', 'CA', '92424', 67000, 6, 'jshemmans5@woothemes.com', '114-33-9719');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (7,'Maurits', 'Chrismas', '619-507-8595', 'Dispatcher', '$17554.17', '4/28/2009', '052 Dahle Plaza', 'San Diego', 'CA', '92191', 78000, 7, 'mchrismas6@kickstarter.com', '231-89-1445');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (8,'Huntlee', 'Huntress', '805-109-9870', 'Driver', '$76534.54', '2/13/2017', '71373 Pine View Alley', 'Santa Barbara', 'CA', '93106', 89000, 8,'hhuntress7@blogs.com', '223-32-5721');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (9,'Etienne', 'Waddington', '562-188-2684', 'Manager', '$10423.81', '4/30/2001', '59 Barby Point', 'Long Beach', 'CA', '90847', 98000, 9, 'ewaddington8@salon.com', '296-06-0266');
insert into Employee (EmployeeID,FName, LName, Phone, Position, Salary, SDate, StreetName, City, State, Zip, LNum, BNum, Email, SSN) values (10,'Cheston', 'Thompkins', '626-145-7789', 'Dispatcher', '$79168.62', '3/11/2008', '982 Esker Road', 'Anaheim', 'CA', '92805', 10000, 10, 'cthompkins9@1688.com', '774-58-1056');
-- Client
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (1, 'Garald', 'De Cruz', 'gdecruz0@bloomberg.com', '805-346-7783', '65 Elka Circle', 'San Mateo', 'CA', '94405', 'Mydo');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (2, 'Freddi', 'Floris', 'ffloris1@nytimes.com', '951-240-5919', '9948 Sundown Drive', 'Riverside', 'CA', '92519', 'Gigabox');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (3, 'Clarance', 'Grubbe', 'cgrubbe2@yelp.com', '310-654-8928', '4 American Ash Circle', 'Los Angeles', 'CA', '90071', 'Vitz');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (4, 'Gabriello', 'Cantrell', 'gcantrell3@xrea.com', '415-395-6080', '9 Havey Street', 'San Francisco', 'CA', '94137', 'Quatz');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (5, 'Tomi', 'Sirrell', 'tsirrell4@examiner.com', '707-160-8061', '38289 Loftsgordon Place', 'Petaluma', 'CA', '94975', 'Mymm');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (6, 'Maisey', 'Hadenton', 'mhadenton5@friendfeed.com', '714-515-3857', '31 Arrowood Trail', 'Anaheim', 'CA', '92825', 'Kare');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (7, 'Aimee', 'Pittel', 'apittel6@furl.net', '559-307-4377', '29749 New Castle Parkway', 'Fullerton', 'CA', '92640', 'Centimia');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (8, 'Kirby', 'Clurow', 'kclurow7@gnu.org', '559-737-5033', '5 Rusk Drive', 'Fresno', 'CA', '93773', 'Eayo');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (9, 'Micky', 'Cantrell', 'mcantrell8@squidoo.com', '916-395-6954', '19 Moose Lane', 'Sacramento', 'CA', '95852', 'Dynabox');
insert into Client (ClientID, FName, LName, Email, Phone, StreetName, City, State, Zip, CompName) values (10, 'Moira', 'Beange', 'mbeange9@smugmug.com', '626-372-9260', '155 Dixon Junction', 'Pasadena', 'CA', '91199', 'Tekfly');
--delivery
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (39, 6, 1, '5/6/2018', '4:03 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (10, 1, 2, '7/7/2017', '12:35 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (25, 8, 3, '10/23/2018', '6:17 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (45, 2, 4, '8/12/2017', '12:34 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (18, 6, 5, '3/7/2019', '6:14 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (28, 8, 6, '7/27/2017', '9:49 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (39, 9, 7, '2/3/2018', '2:31 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (18, 5, 8, '12/6/2017', '1:20 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (41, 7, 9, '2/17/2019', '10:00 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 2, 10, '11/24/2018', '6:27 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (27, 3, 11, '2/19/2018', '4:34 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (25, 7, 12, '7/19/2017', '5:37 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (3, 5, 13, '7/19/2017', '2:27 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (49, 8, 14, '7/7/2018', '11:26 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (38, 3, 15, '8/17/2017', '8:25 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (8, 3, 16, '12/6/2017', '4:09 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (26, 2, 17, '4/29/2017', '1:46 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (40, 9, 18, '10/17/2017', '7:51 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (31, 3, 19, '8/15/2017', '10:13 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (19, 3, 20, '7/18/2017', '8:20 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (38, 9, 21, '7/6/2017', '6:49 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (7, 5, 22, '4/6/2018', '8:15 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (36, 2, 23, '10/15/2018', '9:13 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 8, 24, '5/22/2018', '10:46 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (36, 1, 25, '8/28/2018', '8:03 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (41, 1, 26, '7/27/2018', '10:26 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (41, 4, 27, '2/9/2019', '9:44 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (6, 6, 28, '2/19/2018', '6:56 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (9, 10, 29, '4/30/2017', '12:11 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (44, 6, 30, '6/9/2017', '6:33 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (13, 6, 31, '7/27/2018', '2:07 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (7, 6, 32, '12/10/2018', '6:44 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (37, 9, 33, '5/18/2017', '2:39 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (7, 5, 34, '4/22/2017', '9:57 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (48, 3, 35, '12/31/2017', '3:21 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (10, 10, 36, '8/2/2018', '3:24 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (24, 2, 37, '10/5/2017', '12:53 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (25, 9, 38, '3/5/2019', '3:18 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (16, 9, 39, '12/3/2017', '9:43 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (29, 3, 40, '2/18/2018', '6:25 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (19, 10, 41, '3/12/2019', '6:08 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 6, 42, '7/30/2017', '5:56 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (31, 9, 43, '11/7/2017', '1:09 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (48, 6, 44, '5/7/2018', '9:44 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (42, 8, 45, '8/3/2017', '8:51 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (39, 3, 46, '4/4/2018', '3:55 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (49, 6, 47, '6/14/2018', '10:34 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (44, 7, 48, '5/15/2017', '12:32 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (37, 7, 49, '8/30/2017', '3:50 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (13, 9, 50, '4/19/2017', '11:45 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (41, 1, 1, '10/28/2018', '4:40 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (29, 10, 2, '3/16/2019', '8:56 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (15, 3, 3, '11/14/2017', '3:25 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (33, 9, 4, '6/19/2018', '10:27 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 1, 5, '7/3/2017', '10:29 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (50, 7, 6, '8/6/2017', '8:10 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (12, 1, 7, '12/4/2018', '10:35 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (2, 4, 8, '12/10/2018', '8:46 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 10, 9, '3/9/2018', '6:59 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (2, 3, 10, '6/15/2018', '4:36 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (20, 3, 11, '1/26/2019', '6:51 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (44, 10, 12, '4/17/2018', '1:21 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 1, 13, '10/15/2017', '1:50 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (17, 6, 14, '7/22/2017', '3:29 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (4, 4, 15, '4/3/2017', '5:38 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (49, 2, 16, '9/29/2018', '1:23 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 1, 17, '9/5/2018', '1:05 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (24, 8, 18, '2/8/2018', '12:36 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (43, 9, 19, '8/23/2018', '5:20 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (12, 2, 20, '9/18/2018', '11:51 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (28, 9, 21, '10/19/2018', '9:31 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (21, 1, 22, '11/21/2017', '8:14 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (43, 10, 23, '2/3/2019', '9:29 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (19, 5, 24, '7/8/2017', '7:24 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (10, 6, 25, '3/2/2018', '10:59 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (19, 8, 26, '1/10/2018', '6:34 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (17, 2, 27, '3/17/2019', '6:15 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (7, 5, 28, '6/2/2017', '5:40 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 9, 29, '7/20/2017', '3:35 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (14, 10, 30, '12/15/2018', '12:50 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (25, 4, 31, '6/29/2017', '10:44 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (42, 7, 32, '8/7/2017', '11:38 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (28, 9, 33, '10/3/2018', '8:50 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (38, 1, 34, '9/20/2018', '4:35 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (37, 7, 35, '11/23/2018', '2:25 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (19, 6, 36, '1/4/2018', '5:57 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (12, 10, 37, '8/19/2018', '6:31 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (26, 5, 38, '12/30/2018', '8:26 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (14, 10, 39, '8/8/2017', '5:34 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (5, 9, 40, '12/21/2017', '12:05 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (17, 9, 41, '7/12/2017', '11:16 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (35, 4, 42, '12/16/2018', '8:26 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 4, 43, '12/4/2017', '1:49 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (22, 5, 44, '12/13/2017', '1:05 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 4, 45, '7/6/2018', '10:15 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (30, 1, 46, '10/15/2017', '6:20 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 1, 47, '9/15/2018', '8:14 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 6, 48, '1/27/2018', '1:36 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (12, 8, 49, '5/15/2018', '4:11 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (18, 3, 50, '9/2/2018', '7:06 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (9, 6, 1, '5/10/2017', '10:05 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (11, 2, 2, '4/6/2018', '6:03 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (18, 8, 3, '10/19/2018', '11:12 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 5, 4, '5/26/2018', '7:03 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (17, 9, 5, '4/12/2018', '8:01 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (30, 1, 6, '8/3/2018', '12:22 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 3, 7, '11/12/2017', '8:59 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (17, 5, 8, '6/13/2018', '2:29 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (50, 4, 9, '3/17/2018', '2:10 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (43, 9, 10, '5/13/2017', '9:13 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (9, 7, 11, '7/10/2018', '6:42 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (36, 6, 12, '1/16/2018', '3:49 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (8, 4, 13, '4/13/2018', '12:25 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 9, 14, '4/6/2018', '7:47 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (6, 1, 15, '6/30/2017', '9:32 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (36, 7, 16, '2/15/2018', '8:15 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (24, 1, 17, '1/8/2019', '8:31 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 2, 18, '8/7/2017', '7:04 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (45, 4, 19, '2/3/2018', '3:13 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (5, 6, 20, '3/27/2018', '12:37 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (38, 1, 21, '2/23/2018', '4:11 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (24, 10, 22, '8/12/2017', '5:37 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (33, 2, 23, '5/11/2017', '6:22 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (43, 4, 24, '11/22/2018', '7:56 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (35, 6, 25, '5/14/2018', '3:37 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (20, 3, 26, '8/19/2017', '12:41 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 7, 27, '11/29/2018', '4:34 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (14, 7, 28, '10/10/2017', '7:43 PM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (8, 9, 29, '11/21/2017', '11:11 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (7, 8, 30, '9/14/2017', '7:20 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (22, 4, 31, '7/1/2018', '8:16 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (2, 5, 32, '2/10/2019', '7:39 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (16, 4, 33, '12/18/2017', '1:41 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (44, 5, 34, '5/12/2018', '3:12 PM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (37, 10, 35, '9/10/2018', '2:28 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 7, 36, '1/18/2019', '4:12 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (14, 8, 37, '9/22/2018', '12:20 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (34, 10, 38, '9/19/2018', '7:44 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (13, 9, 39, '8/4/2017', '4:33 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (46, 9, 40, '9/1/2018', '11:24 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (23, 8, 41, '2/7/2019', '6:00 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (1, 1, 42, '7/8/2018', '2:49 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (39, 8, 43, '10/17/2018', '5:45 PM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (12, 9, 44, '10/25/2018', '1:09 AM', 5);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (6, 1, 45, '8/13/2017', '3:00 PM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (29, 6, 46, '12/25/2018', '5:11 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (26, 1, 47, '1/15/2019', '8:35 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (15, 7, 48, '2/24/2018', '6:55 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (41, 1, 49, '5/31/2017', '12:13 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (25, 8, 50, '10/12/2018', '6:42 AM', 1);

-- Location
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (1, '89425 Kipling Street', 'Baton Rouge', 'LA', '70883', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (2, '18459 Butternut Pass', 'Pensacola', 'FL', '32575', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (3, '1 Garrison Street', 'Sparks', 'NV', '89436', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (4, '51872 Hoffman Center', 'Denver', 'CO', '80255', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (5, '9 Myrtle Junction', 'Bellevue', 'WA', '98008', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (6, '948 Cardinal Place', 'Greensboro', 'NC', '27455', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (7, '620 Washington Drive', 'Las Vegas', 'NV', '89140', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (8, '5950 John Wall Point', 'Baltimore', 'MD', '21265', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (9, '18096 Elmside Way', 'Pittsburgh', 'PA', '15205', null);
insert into Location (LocationID, StreetName, City, State, ZIP, Description) values (10, '21380 Hintze Lane', 'Maple Plain', 'MN', '55572', null);

--OrderContains
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 1, '101', '$3.90', '3/20/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 2, '175', '$2.75', '4/5/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 3, '38', '$1.85', '7/14/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 4, '156', '$3.66', '1/7/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 5, '16 7', '$3.02', '8/3/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 6, '28', '$3.74', '4/8/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 7, '59', '$1.09', '11/5/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 8, '184', '$1.15', '9/15/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 9, '51', '$1.19', '8/3/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 10, '116', '$1.15', '1/13/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 11, '110', '$1.48', '2/23/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 12, '97', '$2.08', '1/7/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 13, '47', '$2.27', '4/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 14, '190', '$1.06', '6/3/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 15, '10', '$1.60', '4/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 16, '39', '$2.99', '3/22/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 17, '67', '$2.78', '9/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 18, '110', '$2.17', '12/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 19, '33', '$3.83', '12/4/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 20, '198', '$2.97', '10/12/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 21, '15', '$1.18', '10/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 22, '49', '$1.33', '12/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 23, '67', '$1.33', '8/31/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 24, '12', '$3.06', '2/14/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 25, '114', '$2.63', '7/6/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 26, '133', '$3.31', '7/23/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 27, '27', '$3.62', '4/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 28, '99', '$1.31', '6/2/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 29, '49', '$3.27', '3/29/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 30, '172', '$3.86', '8/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 31, '22', '$2.30', '1/8/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 32, '90', '$3.76', '10/12/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 33, '96', '$3.76', '10/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 34, '35', '$1.02', '11/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 35, '154', '$2.33', '8/1/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 36, '63', '$2.55', '8/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 37, '185', '$1.41', '4/14/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 38, '166', '$3.96', '1/20/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 39, '129', '$3.45', '10/19/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 40, '136', '$1.27', '12/29/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 41, '3', '$3.40', '3/6/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 42, '105', '$1.19', '4/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 43, '41', '$3.03', '9/21/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 44, '197', '$3.69', '3/16/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 45, '131', '$1.32', '10/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 46, '97', '$1.66', '3/25/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 47, '99', '$3.37', '6/4/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 48, '161', '$2.08', '5/9/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 49, '162', '$3.71', '1/10/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 50, '67', '$2.55', '12/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 1, '137', '$2.48', '11/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 2, '188', '$1.54', '4/25/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 3, '99', '$2.17', '7/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 4, '13', '$2.44', '2/4/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 5, '124', '$3.98', '6/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 6, '143', '$3.45', '9/9/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 7, '104', '$1.07', '6/2/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 8, '175', '$3.66', '3/17/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 9, '51', '$3.73', '7/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 10, '162', '$3.88', '8/29/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 11, '155', '$1.82', '12/1/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 12, '35', '$3.41', '2/24/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 13, '104', '$1.33', '3/8/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 14, '120', '$2.48', '9/2/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 15, '2', '$3.05', '12/3/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 16, '199', '$2.48', '12/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 17, '62', '$2.57', '11/5/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 18, '97', '$2.02', '5/10/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 19, '61', '$3.32', '12/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 20, '104', '$3.96', '9/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 21, '157', '$3.28', '6/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 22, '38', '$3.14', '8/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 23, '137', '$2.11', '12/15/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 24, '160', '$1.47', '4/19/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 25, '103', '$2.75', '12/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 26, '47', '$3.78', '2/29/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 27, '50', '$1.70', '6/30/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 28, '181', '$3.20', '6/12/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 29, '134', '$2.66', '12/12/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 30, '104', '$2.65', '4/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 31, '170', '$3.49', '9/14/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 32, '55', '$3.34', '10/20/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 33, '51', '$3.33', '12/19/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 34, '19', '$3.45', '1/5/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 35, '145', '$1.75', '11/22/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 36, '103', '$2.91', '8/21/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 37, '53', '$4.00', '9/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 38, '22', '$1.36', '6/10/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 39, '168', '$1.60', '5/2/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 40, '32', '$3.59', '6/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 41, '3', '$2.85', '12/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 42, '121', '$2.07', '4/15/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 43, '11', '$3.63', '8/7/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 44, '35', '$3.15', '5/30/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 45, '138', '$3.95', '5/5/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 46, '125', '$1.85', '11/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 47, '2', '$2.31', '4/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 48, '130', '$2.17', '5/19/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 49, '107', '$3.74', '9/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 50, '106', '$3.15', '11/3/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 1, '16 7', '$3.26', '6/29/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 2, '121', '$2.55', '7/21/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 3, '48', '$2.02', '4/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 4, '10', '$1.44', '3/17/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 5, '106', '$1.68', '5/26/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 6, '83', '$2.68', '5/6/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 7, '191', '$3.67', '8/31/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 8, '88', '$3.69', '6/11/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 9, '145', '$1.32', '12/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 10, '170', '$3.56', '1/20/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 11, '34', '$1.55', '8/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 12, '89', '$1.27', '1/7/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 13, '193', '$3.33', '4/9/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 14, '141', '$2.10', '8/29/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 15, '153', '$1.12', '7/24/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 16, '183', '$2.94', '8/23/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 17, '190', '$3.67', '2/16/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 18, '36', '$1.98', '5/31/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 19, '100', '$1.34', '5/1/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 20, '154', '$1.08', '4/27/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 21, '76', '$3.80', '11/16/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 22, '54', '$2.31', '3/16/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 23, '112', '$3.47', '10/1/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 24, '23', '$1.76', '7/15/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 25, '66', '$1.37', '9/18/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 26, '184', '$3.66', '1/14/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 27, '199', '$2.30', '4/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 28, '166', '$2.67', '1/11/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 29, '195', '$1.06', '8/27/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (8, 30, '18', '$3.88', '7/15/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (4, 31, '61', '$2.27', '11/14/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 32, '36', '$1.49', '7/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 33, '56', '$3.21', '12/6/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (1, 34, '89', '$1.83', '10/29/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 35, '184', '$1.22', '1/1/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 36, '149', '$3.03', '9/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 37, '22', '$1.93', '3/14/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 38, '30', '$1.01', '3/5/2020');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 39, '57', '$2.18', '8/11/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 40, '103', '$3.74', '11/13/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (9, 41, '6', '$1.37', '4/7/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 42, '79', '$3.06', '12/2/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 43, '27', '$1.85', '4/26/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (7, 44, '176', '$1.99', '7/1/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 45, '194', '$2.07', '6/28/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (2, 46, '161', '$1.91', '9/30/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (5, 47, '124', '$2.08', '11/5/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (6, 48, '20', '$3.60', '8/4/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (10, 49, '184', '$3.42', '10/10/2019');
insert into OrderContains (ItemTypeID, OrderID, NumItemType, ItemTypePrice, ExpDate) values (3, 50, '95', '$2.07', '6/25/2019');

--Orders
insert into Orders (OrderID, SupplierID, OrderType) values (1, 5, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (2, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (3, 2, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (4, 4, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (5, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (6, 4, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (7, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (8, 6, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (9, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (10, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (11, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (12, 1, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (13, 7, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (14, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (15, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (16, 6, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (17, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (18, 2, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (19, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (20, 10, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (21, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (22, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (23, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (24, 6, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (25, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (26, 7, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (27, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (28, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (29, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (30, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (31, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (32, 4, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (33, 5, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (34, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (35, 6, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (36, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (37, 1, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (38, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (39, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (40, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (41, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (42, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (43, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (44, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (45, 4, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (46, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (47, 7, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (48, 4, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (49, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (50, 10, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (51, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (52, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (53, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (54, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (55, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (56, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (57, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (58, 7, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (59, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (60, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (61, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (62, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (63, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (64, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (65, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (66, 4, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (67, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (68, 4, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (69, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (70, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (71, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (72, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (73, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (74, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (75, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (76, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (77, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (78, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (79, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (80, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (81, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (82, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (83, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (84, 5, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (85, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (86, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (87, 1, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (88, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (89, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (90, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (91, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (92, 6, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (93, 2, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (94, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (95, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (96, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (97, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (98, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (99, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (100, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (101, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (102, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (103, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (104, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (105, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (106, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (107, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (108, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (109, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (110, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (111, 1, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (112, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (113, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (114, 9, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (115, 2, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (116, 2, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (117, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (118, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (119, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (120, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (121, 4, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (122, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (123, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (124, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (125, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (126, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (127, 8, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (128, 3, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (129, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (130, 8, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (131, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (132, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (133, 2, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (134, 5, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (135, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (136, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (137, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (138, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (139, 7, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (140, 7, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (141, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (142, 1, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (143, 5, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (144, 6, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (145, 4, 'WarehouseOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (146, 9, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (147, 10, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (148, 3, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (149, 4, 'VendingOrder');
insert into Orders (OrderID, SupplierID, OrderType) values (150, 6, 'VendingOrder');
--Route
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (1, 12000, '5/24/2018', '2:12 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (2, 56000, '7/26/2017', '2:15 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (3, 23000, '8/22/2018', '6:18 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (4, 78000, '6/20/2018', '5:56 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (5, 89000, '2/5/2018', '12:13 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (6, 23000, '10/30/2018', '9:53 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (7, 12000, '7/16/2018', '2:10 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (8, 10000, '10/19/2018', '11:41 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (9, 12000, '12/22/2018', '5:42 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (10, 78000, '10/8/2018', '10:53 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (11, 67000, '2/16/2018', '3:26 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (12, 45000, '5/23/2017', '2:41 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (13, 23000, '3/30/2019', '8:12 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (14, 23000, '9/10/2017', '9:00 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (15, 56000, '10/29/2017', '4:23 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (16, 23000, '12/28/2018', '4:56 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (17, 12000, '9/4/2017', '11:33 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (18, 23000, '5/18/2018', '9:31 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (19, 78000, '5/9/2018', '12:51 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (20, 67000, '5/17/2018', '8:22 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (21, 98000, '8/14/2017', '10:27 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (22, 98000, '7/20/2017', '4:44 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (23, 10000, '9/17/2017', '3:30 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (24, 78000, '11/27/2018', '3:01 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (25, 78000, '1/27/2019', '4:43 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (26, 10000, '12/11/2017', '7:54 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (27, 23000, '7/25/2018', '3:32 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (28, 89000, '12/23/2017', '10:42 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (29, 12000, '4/20/2018', '9:17 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (30, 56000, '4/15/2018', '10:44 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (31, 56000, '3/26/2018', '11:24 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (32, 67000, '1/9/2018', '7:25 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (33, 98000, '7/10/2018', '12:13 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (34, 98000, '1/30/2018', '11:22 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (35, 78000, '10/13/2018', '5:31 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (36, 12000, '10/28/2018', '7:21 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (37, 23000, '1/4/2019', '3:21 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (38, 67000, '5/11/2018', '2:08 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (39, 78000, '5/29/2018', '2:55 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (40, 45000, '12/3/2017', '9:50 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (41, 67000, '12/27/2017', '4:04 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (42, 56000, '3/2/2019', '3:16 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (43, 10000, '8/18/2017', '1:19 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (44, 45000, '5/19/2018', '10:52 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (45, 89000, '7/1/2018', '5:51 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (46, 67000, '12/25/2018', '8:25 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (47, 10000, '12/6/2017', '10:23 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (48, 78000, '5/1/2017', '1:44 AM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (49, 10000, '4/21/2017', '6:24 PM');
insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (50, 10000, '11/28/2018', '8:56 AM');
--vending machine
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (1, 1, 10, null, 10, 610);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (2, 7, 10, null, 15, 467);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (3, 10, 8, null, 10, 200);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (4, 8, 8, null, 20, 631);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (5, 5, 8, null, 15, 786);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (6, 8, 1, null, 10, 639);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (7, 2, 5, null, 15, 678);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (8, 10, 7, null, 20, 205);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (9, 8, 9, null, 15, 544);
insert into VendingMachine (MachineID, ClientID, LocationID, Build, ItemsPerSlot, Capacity) values (10, 10, 8, null, 15, 540);




--extra 
UPDATE location set description = 'csub' where locationid = 1;
UPDATE employee set sdate = '2019-01-01'::date where employeeid = 2;

insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 1, '1/7/2019', '7:42 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 2, '10/8/2017', '3:31 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 3, '10/28/2017', '8:48 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 4, '11/11/2017', '1:59 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 5, '12/25/2018', '5:45 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 6, '6/5/2017', '7:53 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 7, '10/13/2018', '7:00 PM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 8, '10/14/2017', '9:16 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 9, '9/21/2017', '6:23 AM');
insert into OrdersFrom (BadgeNumber, SupplierID, DateOrdered, TimeOrdered) values (1, 10, '7/5/2017', '7:35 AM');

insert into Route (RouteID, LicenseNumber, DateCreated, TimeCreated) values (51, 12000, '7/2/2018', '6:42 PM');

insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 1, 1, '5/21/2017', '8:21 AM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 2, 2, '2/5/2018', '8:24 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 3, 3, '12/31/2017', '12:34 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 4, 4, '10/30/2018', '6:04 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 5, 5, '12/7/2018', '11:01 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 6, 6, '11/9/2018', '10:41 AM', 1);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 7, 7, '7/8/2017', '9:39 AM', 2);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 8, 8, '4/7/2017', '9:06 PM', 3);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 9, 9, '6/24/2017', '5:43 AM', 4);
insert into Delivery (RouteID, LocationID, OrderID, Odate, TimeArrived, TimeSpent) values (51, 10, 10, '8/11/2018', '4:02 AM', 4);




