Instructions (Question 1 through 10):
Step 1: the PostgreSQL sample databasecode file used in this assignment:
Crete a new database in PostgreSQL using the sample code file asshown in class (please remember NOT tocopy the file's content directly from Canvas preview as it will notcopy the statements correctly and the code may not work inPostgreSQL when pasted. Instead, download the text file first, openit, and then copy its content).
Step 2: Proceed to compose SQL statementsto answer the queries posed in this assignment. Run the statementsagainst the sample database in PostgreSQL. Make note of the resultsyou obtain and compare it to the answers provided to help you findthe right answer option for each question.
Question 9
What is the summation of all the average cost of cars for eachdistributor?
Group of answer choices
987764.87
598644.37
455454.54
545555.54
98777.34
610001.23
989898.34
87654761.23
847940.14
510984.34
--DB has to exist first in PostgreSQL CREATE TABLE Cars ( C id integer, C brand color C condition primary key (C_id) varchar (15), varchar (15), varchar (15), ); CREATE TABLE Dealers ( D id integer, D name D location varchar (15), varchar (15), primary key (D_id) ); CREATE TABLE Inventory ( C id D id integer, integer, cost PerCar numeric, inStock integer, primary key (C_id, D_id), foreign key (C_id) references Cars (C_id), foreign key (D_id) references Dealers (D_id) ); --Inserts for Cars INSERT INTO Cars VALUES (1, 'Isuzu', 'Fuscia', 'New'); INSERT INTO Cars VALUES (2, 'Mercedes-Benz', 'Yellow', 'New'); VALUES (3, 'Dodge', 'Red', 'Used'); VALUES (4, 'Ford', 'Teal', 'New'); VALUES (5, 'Dodge', 'Blue', 'New'); VALUES (6, 'Cadillac', 'Mauv', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (7,'Jaguar', 'Orange', 'Used'); INSERT INTO Cars VALUES (8, 'Ford', 'Pink', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (12, INSERT INTO Cars VALUES (13, 'Plymouth', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (14, 'Mitsubishi', 'Violet', 'New'); INSERT INTO Cars VALUES (15, 'Volvo', 'Orange', 'New'); VALUES (9, 'Cadillac', 'Crimson', 'Used'); VALUES (10, 'Suzuki', 'Maroon', 'New'); VALUES (11, 'Cadillac', 'Purple', 'Used'); 'GMC', 'Violet', 'New'); INSERT INTO Cars VALUES (16, 'BMW', 'Blue', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (17, 'Isuzu', 'Purple', 'Used'); VALUES (18, 'Nissan', 'Purple', 'Used'); VALUES (19, 'Volkswagen', 'Maroon', 'New'); VALUES (20, 'BMW', 'Aquamarine', 'New'); VALUES (21, 'Lotus', 'Maroon', 'Used'); VALUES (22, 'Chevrolet', 'Violet', 'Used'); VALUES (23, 'GMC', 'Orange', 'New'); VALUES (24, 'Chevrolet', 'Purple', 'Used'); VALUES (25, 'GMC', 'Aquamarine', 'Used'); VALUES (26, 'Suzuki', 'Chrome', 'Used'); VALUES (27, 'Chevrolet', 'Black', 'Used'); INSERT INTO Cars VALUES (28, 'Buick', 'Aquamarine', 'New'); INSERT INTO Cars VALUES (29, 'Mercedes-Benz', 'Goldenrod', 'New');
INSERT INTO Cars VALUES (30, 'Lexus', 'Orange', 'Used'); INSERT INTO Cars VALUES (31, 'Chevrolet', 'Green', 'New'); INSERT INTO Cars VALUES (32, 'Aston Martin', 'Violet', 'Used'); INSERT INTO Cars VALUES (33, 'GMC', 'Yellow', 'New'); INSERT INTO Cars VALUES (34, 'Subaru', 'Yellow', 'New'); INSERT INTO Cars VALUES (35, 'Cadillac', 'White', 'Used'); INSERT INTO Cars VALUES (36, 'Toyota', 'Crimson', 'Used'); INSERT INTO Cars VALUES (37, 'Subaru', 'Khaki', 'Used'); INSERT INTO Cars VALUES (38, 'Chevrolet', 'Blue', 'New'); INSERT INTO Cars VALUES (39, 'Mitsubishi', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (40, 'Subaru', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (41, 'Nissan', 'Violet', 'Used'); INSERT INTO Cars VALUES (42, 'Honda', 'White', 'New'); INSERT INTO Cars VALUES (43, 'Nissan', 'Blue', 'Used'); INSERT INTO Cars INSERT INTO Cars VALUES (45, INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (44, 'Mercedes-Benz', 'Mauv', 'Used'); 'Mitsubishi', 'Red', 'New'); VALUES (46, 'Chevrolet', 'Maroon', 'Used'); VALUES (47, 'Toyota', 'Red', 'Used'); VALUES (48, 'Nissan', 'Pink', 'Used'); VALUES (49, 'Honda', 'Mauv', 'New'); VALUES (50, 'Volvo', 'Maroon', 'Used'); 'Mitsubishi', 'White', 'Used'); VALUES (51, VALUES (52, 'Hyundai', 'Fuscia', 'Used'); VALUES (53, 'Infiniti', 'Maroon', 'Used'); 'Jeep', 'Khaki', 'New'); VALUES (54, VALUES (55, 'Toyota', 'Chrome', 'New'); VALUES (56, 'Mercedes-Benz', 'Orange', 'New'); VALUES (57, 'Toyota', 'Indigo', 'New'); VALUES (58, 'Mitsubishi', 'Turquoise', 'Used'); VALUES (59, 'Mercury', 'Black', 'New'); VALUES (60, 'Nissan', 'Khaki', 'Used'); VALUES (61, 'Land Rover', 'Blue', 'New'); VALUES (62, 'Hummer', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (70, 'Subaru', 'Goldenrod', 'Used'); VALUES (63, 'Chevrolet', 'Aquamarine', 'New'); VALUES (64, 'Hyundai', 'Khaki', 'New'); INSERT INTO Cars VALUES (65, 'Cadillac', 'Teal', 'Used'); INSERT INTO Cars VALUES (66, 'Mitsubishi', 'Pink', 'Used'); INSERT INTO Cars VALUES (67, 'Land Rover', 'Pink', 'New'); INSERT INTO Cars VALUES (68, 'Hyundai', 'Yellow', 'New'); INSERT INTO Cars VALUES (69, 'Mercury', 'Goldenrod', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (71, 'Lincoln', 'Indigo', 'Used'); VALUES (72, 'Chevrolet', 'Yellow', 'New'); VALUES (73, 'Cadillac', 'Khaki', 'New'); VALUES (74, 'Dodge', 'Chrome', 'Used'); 'Dodge', 'Mauv', 'Used'); VALUES (75, VALUES (76, VALUES (77, VALUES (78, 'Volvo', 'Blue', 'New'); VALUES (79, VALUES (80, VALUES (81, 'Chrysler','Mauv', 'Used'); VALUES (82, 'Nissan', 'Indigo', 'Used'); INSERT INTO Cars VALUES (83, 'Pontiac', 'Goldenrod', 'Used'); 'Mitsubishi', 'Aquamarine', 'Used'); 'Toyota', 'Khaki', 'New'); 'Mitsubishi', 'Maroon', 'Used'); 'Nissan', 'Aquamarine', 'Used');
INSERT INTO Cars VALUES (84, 'Mazda', 'Crimson', 'Used'); INSERT INTO Cars VALUES (85, 'GMC', 'Green', 'New'); VALUES (86, 'Volkswagen', 'Blue', 'Used'); VALUES (87, 'Acura', 'Fuscia', 'New'); VALUES (88, 'Ford', 'White', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (89, 'Land Rover', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (90, 'Dodge', 'Crimson', 'Used'); INSERT INTO Cars VALUES (91, 'Ford', 'Orange', 'Used'); INSERT INTO Cars VALUES (92, 'Mazda', 'Orange', 'Used'); INSERT INTO Cars VALUES (93, 'Lincoln', 'Crimson', 'Used'); INSERT INTO Cars VALUES (94, 'Toyota', 'Pink', 'Used'); INSERT INTO Cars VALUES (95, 'Chrysler', 'Blue', 'Used'); INSERT INTO Cars INSERT INTO Cars VALUES (96, 'Tesla', 'White', 'Used'); VALUES (97, 'Audi', 'Violet', 'Used'); INSERT INTO Cars VALUES (98, 'Toyota', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (99, 'Chrysler', 'Pink', 'New'); INSERT INTO Cars VALUES (100, 'Ford', 'Green', 'Used'); VALUES (101, 'Subaru', 'Fuscia', 'Used'); VALUES (102, 'Saab', 'Fuscia', 'Used'); VALUES (103, 'Mazda', 'Teal', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (104, 'Panoz', 'Turquoise', 'New'); INSERT INTO Cars VALUES (105, 'Pontiac', 'Blue', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (108, 'Maybach', 'Teal', 'Used'); INSERT INTO Cars VALUES (109, 'Dodge', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (110, 'Ford', 'Turquoise', 'Used'); VALUES (106, 'Toyota', 'Yellow', 'Used'); VALUES (107, 'Audi', 'Maroon', 'New'); INSERT INTO Cars VALUES (111, 'Plymouth', 'Teal', 'New'); VALUES (112, 'Ferrari', 'Crimson', 'Used'); 'Porsche', 'Khaki', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (115, 'Kia', 'Pink', 'New'); VALUES (116, 'GMC', 'Maroon', 'New'); VALUES (117, 'Chevrolet', 'Red', 'Used'); VALUES (118, 'Porsche', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (119, 'Subaru', 'Blue', 'Used'); INSERT INTO Cars VALUES (120, 'Pontiac', 'Aquamarine', 'Used'); VALUES (121, 'Saab', 'Violet', 'New'); VALUES (122, 'Nissan', 'Turquoise', 'New'); VALUES (123, 'Chevrolet', 'Indigo', 'Used'); VALUES (124, 'Acura', 'Mauv', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (113, VALUES (114, 'Lexus', 'White', 'New'); VALUES (125, 'Infiniti', 'Turquoise', 'New'); VALUES (126, 'Dodge', 'White', 'New'); VALUES (127, 'Audi', 'Khaki', 'New'); VALUES (128, 'Mazda', 'Mauv', 'Used'); VALUES (129, 'Maybach', 'Crimson', 'New'); VALUES (130, VALUES (131, VALUES (132, 'Chevrolet', 'Mauv', 'Used'); VALUES (133, 'Suzuki', 'White', 'New'); 'Mazda', 'Maroon', 'Used'); INSERT INTO Cars INSERT INTO Cars SERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (134, INSERT INTO Cars VALUES (135, 'Mercedes-Benz', 'Khaki', 'New'); INSERT INTO Cars VALUES (136, 'Geo', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (137, 'Chevrolet', 'White', 'Used'); 'Mercedes-Benz', 'Green', 'New'); 'Audi', 'White', 'New');
VALUES (142, 'Nissan', 'Fuscia', 'Used'); VALUES (143, 'Bentley', 'Khaki', 'Used'); VALUES (144, 'Pontiac', 'Red', 'Used'); VALUES (145, 'Mitsubishi', 'Indigo', 'New'); VALUES (146, 'Infiniti', 'Aquamarine', 'New'); VALUES (147, 'Jeep', 'Mauv', 'New'); VALUES (148, 'Peugeot', 'Purple', 'New'); VALUES (149, 'Audi', 'Orange', 'Used'); INSERT INTO Cars VALUES (138, 'Saturn', 'Fuscia', 'New'); INSERT INTO Cars VALUES (139, 'Mercury', 'Maroon', 'Used'); INSERT INTO Cars VALUES (140, 'Jaguar', 'Pink', 'Used'); INSERT INTO Cars VALUES (141, 'Scion', 'Red', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (152, 'Dodge', 'Green', 'Used'); VALUES (153, 'Ram', 'Crimson', 'New'); VALUES (154, 'Chevrolet', 'Khaki', 'Used'); VALUES (155, 'Ford', 'Aquamarine', 'New'); VALUES (156, 'Pontiac', 'Maroon', 'Used'); VALUES (157, 'Cadillac', 'Yellow', 'Used'); VALUES (158, 'Alfa Romeo', 'Indigo', 'New'); VALUES (159, 'BMW', 'Khaki', 'Used'); VALUES (160, 'Ford', 'Khaki', 'Used'); VALUES (161, 'Merkur', 'Turquoise', 'New'); VALUES (162, 'Mercury', 'Red', 'New'); VALUES (163, 'Chevrolet', 'Pink', 'Used'); VALUES (164, 'Buick', 'Purple', 'New'); VALUES (165, 'Subaru', 'Red', 'Used'); VALUES (166, 'Eagle', 'Khaki', 'Used'); INSERT INTO Cars VALUES (167, 'Mercedes-Benz', 'Purple', 'Used'); INSERT INTO Cars VALUES (168, 'Toyota', 'Mauv', 'New'); INSERT INTO Cars VALUES (169, 'Nissan', 'Maroon', 'New'); VALUES (150, 'Mercedes-Benz', 'Violet', 'Used'); VALUES (151, 'Audi', 'Pink', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (172, INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (176, 'Suzuki', 'Mauv', 'New'); INSERT INTO Cars VALUES (177, 'MINI', 'Mauv', 'Used'); INSERT INTO Cars VALUES (178, 'Volvo', 'Khaki', 'Used'); INSERT INTO Cars VALUES (179, 'Buick', 'Pink', 'Used'); VALUES (180, 'Mitsubishi', 'Mauv', 'New'); VALUES (181, 'Dodge', 'Indigo', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (182, 'Hyundai', 'Green', 'Used'); VALUES (183, 'Pontiac', 'Fuscia', 'Used'); VALUES (184, 'Toyota', 'Turquoise', 'Used'); SERT INTO Cars VALUES (185, 'Kia', 'Teal', 'Used'); INSERT INTO Cars VALUES (186, 'Kia', 'White', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (170, 'Aston Martin', 'Indigo', 'New'); VALUES (171, 'Mitsubishi', 'Khaki', 'New'); 'Buick', 'Teal', 'New'); VALUES (173, 'Volkswagen', 'Red', 'Used'); VALUES (174, 'Aston Martin', 'White', 'New'); VALUES (175, 'BMW', 'Goldenrod', 'New'); VALUES (187, 'Volkswagen', 'Crimson', 'Used'); VALUES (188, 'Maserati', 'Goldenrod', 'New'); VALUES (189, 'Ford', 'Violet', 'New'); VALUES (190, 'Volkswagen', 'Violet', 'New'); VALUES (191, 'Chevrolet', 'Fuscia', 'New');
INSERT INTO Cars VALUES (192, 'Infiniti', 'Green', 'Used'); INSERT INTO Cars VALUES (193, 'Mercury', 'Orange', 'New'); INSERT INTO Cars VALUES (194, 'Lincoln', 'White', 'New'); INSERT INTO Cars VALUES (195, 'Chrysler', 'Violet', 'Used'); VALUES (196, 'Daewoo', 'Blue', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (197, 'Jaguar','Khaki', 'Used'); VALUES (198, 'Cadillac', 'Maroon', 'Used'); VALUES (199, 'GMC', 'Blue', 'Used'); VALUES (200, 'Jeep', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (201, 'Maybach', 'Turquoise', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (207, 'Chrysler', 'Purple', 'Used'); VALUES (208, 'Nissan', 'Green', 'New'); 'Daihatsu', 'Green', 'New'); VALUES (202, 'Volkswagen', 'Green', 'New'); VALUES (203, 'Lincoln', 'Pink', 'New'); VALUES (204, 'Chevrolet', 'Turquoise', 'Used'); VALUES (205, 'Mercury', 'Yellow', 'New'); VALUES (206, 'BMW', 'Pink', 'Used'); INSERT INTO Cars VALUES (209, VALUES (210, 'Chrysler', 'Maroon', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars 'Lexus', 'Green', 'New'); INSERT INTO Cars VALUES (212, 'Saturn', 'Orange', 'New'); VALUES (211, VALUES (213, 'Jaguar', 'Red', 'Used'); INSERT INTO Cars INSERT INTO Cars VALUES (214, INSERT INTO Cars VALUES (215, INSERT INTO Cars VALUES (216, INSERT INTO Cars VALUES (217, INSERT INTO Cars 'Oldsmobile', 'Indigo', 'Used'); 'Pontiac', 'Teal', 'Used'); 'Ford', 'Maroon', 'Used'); 'Hummer', 'Purple', 'New'); VALUES (218, 'Lincoln', 'Blue', 'Used'); INSERT INTO Cars VALUES (219, 'Land Rover', 'Maroon', 'Used'); INSERT INTO Cars VALUES (220, 'Audi', 'Mauv', 'New'); INSERT INTO Cars VALUES (221, 'Ford', 'Yellow', 'New'); INSERT INTO Cars VALUES (222, 'Plymouth', 'Red', 'New'); INSERT INTO Cars VALUES (223, 'Toyota', 'Orange', 'Used'); INSERT INTO Cars VALUES (224, 'Acura', 'Violet', 'New'); INSERT INTO Cars VALUES (225, 'Dodge', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (226, 'Audi', 'Yellow', 'Used'); INSERT INTO Cars VALUES (227, 'Mercedes-Benz', 'Indigo', 'New'); INSERT INTO Cars VALUES (228, 'Land Rover', 'Teal', 'New'); INSERT INTO Cars VALUES (229, 'Acura', 'Red', 'Used'); INSERT INTO Cars VALUES (230, 'Oldsmobile', 'Turquoise', 'Used'); INSERT INTO Cars VALUES (231, 'Saab', 'Pink', 'Used'); INSERT INTO Cars VALUES (232, 'Subaru', 'Violet', 'Used'); INSERT INTO Cars VALUES (233, 'Infiniti', 'Fuscia', 'New'); 'Pontiac', 'Violet', 'Used'); 'Hyundai', 'Aquamarine', 'Used'); 'Suzuki', 'Blue', 'Used'); 'Lamborghini', 'Pink', 'Used'); INSERT INTO Cars VALUES (234, INSERT INTO Cars VALUES (235, INSERT INTO Cars VALUES (236, INSERT INTO Cars VALUES (237, INSERT INTO Cars VALUES (238, 'Panoz', 'Aquamarine', 'New'); SERT INTO Cars VALUES (239, 'Subaru', 'Mauv', 'New'); INSERT INTO Cars VALUES (240, 'Mercury', 'White', 'New'); INSERT INTO Cars VALUES (241, 'Geo', 'Mauv', 'Used'); INSERT INTO Cars VALUES (242, 'Oldsmobile', 'Orange', 'Used'); INSERT INTO Cars VALUES (243, 'Volkswagen', 'Teal', 'Used'); INSERT INTO Cars VALUES (244, 'Honda', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (245, 'Ford', 'Indigo', 'Used');
INSERT INTO Cars VALUES (246, 'Volkswagen', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (247, 'Lincoln', 'Green', 'New'); INSERT INTO Cars VALUES (248, 'Chevrolet', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (249, 'Audi', 'Turquoise', 'New'); INSERT INTO Cars VALUES (250, 'Volvo', 'Indigo', 'New'); INSERT INTO Cars VALUES (251, 'Buick', 'Mauv', 'Used'); INSERT INTO Cars VALUES (252, 'Volvo', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (253, 'Lincoln', 'Khaki', 'Used'); VALUES (254, 'Mazda', 'Aquamarine', 'Used'); VALUES (255, 'Lamborghini', 'White', 'New'); VALUES (256, 'Lexus', 'Goldenrod', 'New'); VALUES (257, 'Hummer', 'Teal', 'New'); VALUES (258, 'Dodge', 'Teal', 'New'); VALUES (259, 'GMC', 'Fuscia', 'Used'); VALUES (260, 'Volvo', 'Crimson', 'Used'); VALUES (261, 'Mitsubishi', 'Teal', 'Used'); VALUES (262, 'Mitsubishi', 'Crimson', 'Used'); VALUES (263, 'Honda', 'Orange', 'Used'); VALUES (264, 'Pontiac', 'White', 'Used'); VALUES (265, 'GMC', 'Red', 'Used'); VALUES (266, INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars 'Mitsubishi', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (267, 'Buick', 'Crimson', 'New'); INSERT INTO Cars VALUES (268, 'Dodge', 'Yellow', 'Used'); INSERT INTO Cars VALUES (269, 'Dodge', 'Violet', 'New'); INSERT INTO Cars VALUES (270, 'Toyota', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (271, 'Hyundai', 'Crimson', 'New'); INSERT INTO Cars VALUES (272, 'BMW', 'Red', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (275, 'Daihatsu', 'Maroon', 'New'); INSERT INTO Cars VALUES (276, 'Hyundai', 'Pink', 'New'); INSERT INTO Cars VALUES (277, 'Toyota', 'Violet', 'Used'); INSERT INTO Cars VALUES (278, 'Saturn', 'Crimson', 'Used'); INSERT INTO Cars VALUES (279, 'Holden', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (280, 'Jeep', 'Teal', 'Used'); VALUES (273, 'Maserati', 'Turquoise', 'Used'); VALUES (274, 'Mercury', 'Khaki', 'New'); INSERT INTO Cars VALUES (281, 'Lamborghini', 'Crimson', 'New'); INSERT INTO Cars VALUES (282, 'MINI', 'Green', 'Used'); INSERT INTO Cars VALUES (283, 'Infiniti', 'Crimson', 'New'); INSERT INTO Cars VALUES (284, 'Oldsmobile', 'Mauv', 'New'); INSERT INTO Cars VALUES (285, 'Chrysler', 'Crimson', 'New'); INSERT INTO Cars VALUES (286, 'Scion', 'Pink', 'Used'); INSERT INTO Cars VALUES (287, 'Maserati', 'Blue', 'New'); INSERT INTO Cars VALUES (288, 'Volkswagen', 'Yellow', 'New'); INSERT INTO Cars VALUES (289, 'Infiniti', 'Khaki', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (290, 'Dodge', 'Purple', 'Used'); VALUES (291, 'Kia', 'Aquamarine', 'New'); VALUES (292, 'Lincoln', 'Fuscia', 'Used'); SERT INTO Cars VALUES (293, 'Cadillac', 'Pink', 'New'); INSERT INTO Cars VALUES (294, 'Pontiac', 'Crimson', 'New'); INSERT INTO Cars VALUES (295, 'Mazda', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (296, 'Pontiac', 'Orange', 'New'); INSERT INTO Cars VALUES (297, 'Lexus', 'Teal', 'Used'); INSERT INTO Cars VALUES (298, 'Mitsubishi', 'Orange', 'New'); INSERT INTO Cars VALUES (299, 'Honda', 'Goldenrod', 'Used');
INSERT INTO Cars VALUES (300, 'Lamborghini', 'Teal', 'Used'); INSERT INTO Cars VALUES (301, 'Toyota', 'Blue', 'New'); INSERT INTO Cars VALUES (302, 'Lexus', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (303, 'Infiniti', 'Red', 'New'); VALUES (304, 'Aston Martin', 'Aquamarine', 'Used'); VALUES (305, 'Pontiac', 'Green', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (306, 'Honda', 'Violet', 'Used'); INSERT INTO Cars VALUES (307, 'Honda', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (308, 'Mercedes-Benz', 'Pink', 'Used'); INSERT INTO Cars VALUES (309, 'BMW', 'Yellow', 'Used'); INSERT INTO Cars VALUES (310, 'Eagle', 'Red', 'New'); INSERT INTO Cars VALUES (311, 'Toyota', 'Purple', 'New'); INSERT INTO Cars VALUES (312, 'Oldsmobile', 'Khaki', 'Used'); INSERT INTO Cars VALUES (313, 'GMC', 'Crimson', 'Used'); INSERT INTO Cars VALUES (314, 'Mercury', 'Blue', 'New'); INSERT INTO Cars VALUES (315, 'Mazda', 'Indigo', 'New'); INSERT INTO Cars VALUES (316, 'Rambler', 'Pink', 'New'); VALUES (317, 'Mazda', 'Khaki', 'New'); VALUES (318, 'Plymouth', 'Purple', 'Used'); VALUES (319, 'Hummer', 'White', 'New'); VALUES (320, 'Mercury', 'Turquoise', 'New'); VALUES (321, 'Mercedes-Benz', 'Maroon', 'Used'); VALUES (322, 'Pontiac', 'Khaki', 'New'); VALUES (323, 'Honda', 'Maroon', 'Used'); VALUES (324, 'Honda', 'Red', 'Used'); VALUES (325, 'Ford', 'Purple', 'Used'); VALUES (326, 'Suzuki', 'Violet', 'Used'); VALUES (327, 'Isuzu', 'Goldenrod', 'New'); VALUES (328, 'Pontiac', 'Yellow', 'Used'); VALUES (329, 'Volvo', 'Purple', 'Used'); VALUES (330, 'Hyundai', 'Turquoise', 'Used'); 'Saab', 'Maroon', 'New'); VALUES (332, 'Jaguar', 'White', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (331, VALUES (334, INSERT INTO Cars INSERT INTO Cars VALUES (333, INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars SERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars 'Chrysler', 'Indigo', 'Used'); 'Mitsubishi', 'Green', 'Used'); VALUES (335, VALUES (336, VALUES (337, VALUES (338, VALUES (339, VALUES (340, 'Hyundai', 'Red', 'Used'); VALUES (341, 'Chrysler', 'Goldenrod', VALUES (342, 'Honda', 'Indigo', 'Used'); VALUES (343, 'Honda', 'Turquoise', 'Used'); VALUES (344, 'Suzuki', 'Pink', 'Used'); VALUES (345, 'BMW', 'Mauv', 'New'); 'Acura', 'Yellow', 'New'); 'Lincoln', 'Turquoise', 'Used'); 'Buick', 'Fuscia', 'New'); 'Mercury', 'Pink', 'New'); 'Oldsmobile', 'White', 'Used'); 'New'); VALUES (346, 'Porsche', 'Teal', 'Used'); VALUES (347, 'Fer ci', 'Fuscia', 'New'); VALUES (348, 'Lincoln', 'Mauv', 'New'); VALUES (349, 'Spyker', 'Maroon', 'Used'); VALUES (350, 'Land Rover', 'Violet', 'New'); VALUES (351, 'Nissan', 'Teal', 'Used'); VALUES (352, 'Mitsubishi', 'Blue', 'New'); VALUES (353, 'Saab', 'Crimson', 'Used');
INSERT INTO Cars VALUES (354, 'Saab', 'Khaki', 'New'); INSERT INTO Cars VALUES (355, 'Fiat', 'Yellow', 'Used'); VALUES (356, 'BMW', 'Indigo', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (380, 'Lotus', 'Orange', 'Used'); INSERT INTO Cars VALUES (381,'Hummer', 'Fuscia', 'New'); VALUES (357, 'Volvo', 'Aquamarine', 'New'); VALUES (358, 'Ford', 'Red', 'Used'); VALUES (359, 'Toyota', 'Green', 'New'); VALUES (360, 'Audi', 'Aquamarine', 'New'); VALUES (361, 'Jeep', 'Purple', 'Used'); VALUES (362, 'Porsche', 'White', 'New'); VALUES (363, 'Lexus', 'Red', 'New'); VALUES (364, 'Ford', 'Blue', 'New'); VALUES (365, 'Jaguar', 'Green', 'New'); VALUES (366, 'Porsche', 'Aquamarine', 'Used'); VALUES (367, 'Mazda', 'Yellow', 'New'); VALUES (368, 'Bentley', 'Goldenrod', 'Used'); VALUES (369, 'Honda', 'Yellow', 'New'); VALUES (370, 'Porsche', 'Blue', 'Used'); VALUES (371, 'Saab', 'Blue', 'New'); VALUES (372, 'Kia', 'Turquoise', 'Used'); VALUES (373, 'Mercury', 'Green', 'Used'); VALUES (374, 'Acura', 'Green', 'Used'); VALUES (375, 'Porsche', 'Turquoise', 'Used'); VALUES (376, 'Pontiac', 'Turquoise', 'New'); VALUES (377, 'Saab', 'Indigo', 'Used'); VALUES (378, 'Mercedes-Benz', 'White', 'Used'); VALUES (379, 'Ford', 'Fuscia', 'New'); INSERT INTO Cars VALUES (382, 'Volkswagen', 'Turquoise', 'Used'); INSERT INTO Cars VALUES (383, 'Volkswagen', 'Pink', 'Used'); INSERT INTO Cars VALUES (384, 'Hyundai', 'White', 'New'); INSERT INTO Cars VALUES (385, 'Volkswagen', 'Mauv', 'Used'); INSERT INTO Cars VALUES (386, 'Isuzu', 'Turquoise', 'New'); INSERT INTO Cars VALUES (387, 'Chrysler', 'Orange', 'Used'); INSERT INTO Cars VALUES (388, 'Cadillac', 'Red', 'New'); INSERT INTO Cars VALUES (389, 'Buick', 'Indigo', 'Used'); INSERT INTO Cars VALUES (390, 'Honda', 'Green', 'New'); VALUES (391, 'Maserati', 'Fuscia', 'New'); VALUES (392, 'Tesla', 'Mauv', 'Used'); VALUES (393, 'Subaru', 'Orange', 'Used'); VALUES (394, 'MINI', 'Violet', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (395, 'Ford', 'Goldenrod', 'Used'); VALUES (396, 'Plymouth', 'Blue', 'New'); VALUES (397, 'Rolls-Royce', 'White', 'Used'); VALUES (398, 'Dodge', 'Turquoise', 'Used'); VALUES (399, 'Dodge', 'Orange', 'Used'); VALUES (400, 'Lexus', 'Mauv', 'Used'); VALUES (401, 'Hummer', 'Orange', 'Used'); VALUES (402, 'Kia', 'Mauv', 'Used'); SERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (403, 'Infiniti', 'Purple', 'New'); INSERT INTO Cars VALUES (404, 'Suzuki', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (405, 'Kia', 'Blue', 'Used'); INSERT INTO Cars VALUES (406, 'Ford', 'Crimson', 'Used'); INSERT INTO Cars VALUES (407, 'Acura', 'Maroon', 'New');
'New'); INSERT INTO Cars VALUES (408, 'Nissan', 'Crimson', INSERT INTO Cars VALUES (409, 'Volvo', 'Mauv', 'Used'); INSERT INTO Cars VALUES (410, 'Ford', 'Mauv', 'Used'); INSERT INTO Cars VALUES (411, 'Bentley','Purple','Used'); INSERT INTO Cars VALUES (412, 'Buick', 'Yellow', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (413, 'Mercury', 'Violet', 'Used'); VALUES (414, 'Jeep', 'Orange', 'Used'); VALUES (415, 'Oldsmobile', 'Yellow', 'Used'); INSERT INTO Cars VALUES (416, 'Mercedes-Benz', 'Blue', 'Used'); INSERT INTO Cars VALUES (417, 'GMC', 'Teal', 'New'); INSERT INTO Cars VALUES (418, 'Suzuki', 'Red', 'Used'); INSERT INTO Cars VALUES (419, 'Lincoln', 'Purple', 'New'); INSERT INTO Cars VALUES (420, 'Cadillac', 'Aquamarine', 'New'); INSERT INTO Cars VALUES (421, 'Mazda', 'Turquoise', 'New'); INSERT INTO Cars VALUES (422, 'Dodge', 'Fuscia', 'Used'); INSERT INTO Cars VALUES (423, 'Panoz', 'Khaki', 'Used'); INSERT INTO Cars VALUES (424, 'Toyota', 'Maroon', 'New'); INSERT INTO Cars VALUES (425, 'Cadillac', 'Blue', 'New'); INSERT INTO Cars VALUES (426, 'Chrysler', 'White', 'Used'); INSERT INTO Cars VALUES (427, 'Dodge', 'Maroon', 'New'); INSERT INTO Cars VALUES (428, 'Lamborghini', 'Blue', 'New'); INSERT INTO Cars VALUES (429, 'Lotus', 'Purple', 'Used'); INSERT INTO Cars VALUES (430, 'Suzuki', 'Orange', 'New'); INSERT INTO Cars VALUES (431, 'Nissan', 'Yellow', 'Used'); INSERT INTO Cars VALUES (432, 'Oldsmobile', 'Pink', 'New'); INSERT INTO Cars VALUES (433, 'Pontiac', 'Indigo', 'New'); INSERT INTO Cars VALUES (434, 'Audi', 'Crimson', 'New'); INSERT INTO Cars VALUES (435, 'Lotus', 'Violet', 'New'); INSERT INTO Cars VALUES (436, 'Saab', 'Turquoise', 'Used'); INSERT INTO Cars VALUES (437, 'Chrysler', 'Aquamarine', 'Used'); INSERT INTO Cars VALUES (438, 'Lincoln', 'Goldenrod', 'New'); INSERT INTO Cars VALUES (439, 'Land Rover', 'Indigo', 'New'); INSERT INTO Cars VALUES (440, 'Nissan', 'Goldenrod', 'Used'); INSERT INTO Cars VALUES (441, 'Aston Martin', 'Khaki', 'Used'); INSERT INTO Cars VALUES (442, 'GMC', 'White', 'New'); INSERT INTO Cars VALUES (443, 'Mazda', 'Violet', 'Used'); INSERT INTO Cars VALUES (444, 'Chevrolet', 'Crimson', 'New'); INSERT INTO Cars VALUES (445, 'Acura', 'Pink', 'Used'); VALUES (446, 'Hyundai', 'Teal', 'New'); VALUES (447, 'Plymouth', 'Khaki', 'Used'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (448, 'Jeep', 'Maroon', 'New'); VALUES (449, 'Lamborghini', 'Maroon', 'New'); INSERT INTO Cars VALUES (450, 'MINI', 'Turquoise', 'New'); INSERT INTO Cars VALUES (451, 'Hyundai', 'Violet', 'Used'); INSERT INTO Cars VALUES (452, 'Isuzu', 'Pink', 'Used'); INSERT INTO Cars VALUES (453, INSERT INTO Cars VALUES (454, SERT INTO Cars VALUES (455, INSERT INTO Cars VALUES (456, INSERT INTO Cars 'Kia', 'Crimson', 'New'); VALUES (457, 'Mazda', 'Blue', 'New'); INSERT INTO Cars VALUES (458, 'Saturn', 'Violet', 'Used'); INSERT INTO Cars VALUES (459, 'Volvo', 'Teal', 'Used'); INSERT INTO Cars VALUES (460, 'Isuzu', 'Indigo', 'Used'); INSERT INTO Cars VALUES (461, 'Subaru', 'Purple', 'New'); 'Lincoln', 'Teal', 'Used'); 'Ferrari', 'Turquoise', 'New'); 'Porsche', 'Mauv', 'Used');
INSERT INTO Cars VALUES (462, 'Mercury', 'Mauv', 'New'); INSERT INTO Cars VALUES (463, 'Mazda', 'Pink', 'New'); VALUES (474, 'Mercedes-Benz', 'Aquamarine', 'New'); VALUES (475, 'Lotus', 'Green', 'Used'); INSERT INTO Cars VALUES (464, 'Hummer', 'Crimson', 'Used'); INSERT INTO Cars VALUES (465, 'Audi', 'Blue', 'New'); INSERT INTO Cars VALUES (466, 'GMC', 'Turquoise', 'Used'); INSERT INTO Cars VALUES (467, 'Mercedes-Benz', 'Red', 'Used'); INSERT INTO Cars VALUES (468, 'Mercedes-Benz', 'Teal', 'New'); INSERT INTO Cars VALUES (469, 'Plymouth', 'Turquoise', 'New'); INSERT INTO Cars VALUES (470, 'BMW', 'Crimson', 'New'); INSERT INTO Cars VALUES (471, 'Hyundai', 'Indigo', 'Used'); INSERT INTO Cars VALUES (472, 'Smart', 'Maroon', 'Used'); INSERT INTO Cars VALUES (473, 'Porsche', 'Indigo', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (476, 'Honda', 'Purple', 'Used'); INSERT INTO Cars VALUES (477, 'Geo', 'Purple', 'New'); INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars INSERT INTO Cars VALUES (481, 'Mercedes-Benz', 'Fuscia', 'New'); INSERT INTO Cars VALUES (482, 'Buick', 'Turquoise', 'New'); INSERT INTO Cars VALUES (483, 'Lotus', 'Yellow', 'New'); INSERT INTO Cars VALUES (484, 'Suzuki', 'Yellow', 'Used'); INSERT INTO Cars VALUES (485, 'Daewoo', 'Violet', 'Used'); INSERT INTO Cars VALUES (486, 'Subaru', 'Teal', 'Used'); INSERT INTO Cars VALUES (487, 'Kia', 'Orange', 'Used'); INSERT INTO Cars VALUES (488, 'BMW', 'Maroon', 'Used'); INSERT INTO Cars VALUES (489, 'Volkswagen', 'Orange', 'Used'); INSERT INTO Cars VALUES (490, 'Buick', 'Blue', 'New'); INSERT INTO Cars VALUES (491, 'BMW', 'Orange', 'Used'); INSERT INTO Cars VALUES (492, 'Saturn', 'Aquamarine', 'New'); INSERT INTO Cars VALUES (493, 'Isuzu', 'Aquamarine', 'New'); INSERT INTO Cars VALUES (494, 'Plymouth', 'Indigo', 'Used'); INSERT INTO Cars VALUES (495, 'Infiniti', 'Orange', 'Used'); INSERT INTO Cars VALUES (496, 'Mazda', 'White', 'New'); VALUES (478, 'Suzuki', 'Purple', 'Used'); VALUES (479, 'Mazda', 'Purple', 'New'); VALUES (480, 'Buick', 'Red', 'Used'); INSERT INTO Cars VALUES (497, 'Volkswagen', 'Aquamarine', 'New'); INSERT INTO Cars VALUES (498, 'Alfa Romeo', 'Blue', 'New'); INSERT INTO Cars VALUES (499, 'Lincoln', 'Red', 'Used'); INSERT INTO Cars VALUES (500, 'Bentley', 'Turquoise', 'Used'); --Inserts for Dealers INSERT INTO Dealers VALUES (1, 'CarsMax', 'Miami'); INSERT INTO Dealers VALUES (2, 'MaxiCar', 'Chicago'); INSERT INTO Dealers VALUES (3, 'SuperCars', 'Tampa'); INSERT INTO Dealers VALUES (4, 'LordOfCars', 'Miami'); INSERT INTO Dealers VALUES (5, 'CarsUnited', 'Atlanta'); INSERT INTO Dealers VALUES (6, 'Cars4All', 'Orlando'); INSERT INTO Dealers INSERT INTO Deale INSERT INTO Dealers INSERT INTO Dealers VALUES (10, 'Carvana', 'Tampa'); INSERT INTO Dealers VALUES (11, 'Cars Fast', 'Tampa'); INSERT INTO Dealers VALUES (12, 'Engines2Go', 'Miami'); INSERT INTO Dealers VALUES (13, 'DriversFirst', 'Chicago'); INSERT INTO Dealers VALUES (14, 'West Cars', 'Naples'); VALUES (7, 'BestCars', 'Naples'); VALUES (8, 'CarValue', 'Miami'); VALUES (9, 'FortCars', 'Orlando');
INSERT INTO Dealers VALUES (15, 'SouthMotors', 'Tampa'); --Inserts for Inventory INSERT INTO Inventory VALUES (1,5, 72734,113); INSERT INTO Inventory VALUES (2,9,72540, 106); INSERT INTO Inventory VALUES (2,15,17341,188); INSERT INTO Inventory VALUES (3,1, 43420,209); INSERT INTO Inventory VALUES (3,8,42239, 240); INSERT INTO Inventory VALUES (3,12,42064,58); INSERT INTO Inventory VALUES (4,7,57561,9); INSERT INTO Inventory VALUES (4,8, 36708,261); INSERT INTO Inventory VALUES (4,12,38377,241); INSERT INTO Inventory VALUES (5,13,42890,185); INSERT INTO Inventory VALUES (6, 6, 42902, 223); INSERT INTO Inventory VALUES (6,14,31277,87); INSERT INTO Inventory VALUES (6,15,16245,175); INSERT INTO Inventory VALUES (7,1,1141,54); INSERT INTO Inventory VALUES (7,4, 13205, 289); INSERT INTO Inventory VALUES (7,8,79860, 296); INSERT INTO Inventory VALUES (7,13,51249,274); INSERT INTO Inventory VALUES (8,3,72834,204); INSERT INTO Inventory VALUES (8,6, 47999, 211); INSERT INTO Inventory VALUES (8,8,10901,248); INSERT INTO Inventory VALUES (8,12,19633,164); INSERT INTO Inventory VALUES (9,8,34748,248); INSERT INTO Inventory VALUES (9, 12, 38566,98); INSERT INTO Inventory VALUES (9,13,75394,177); INSERT INTO Inventory VALUES (10, 6, 10659,238); INSERT INTO Inventory VALUES (10,7,17723,0); INSERT INTO Inventory VALUES (10,12,12995, 175); INSERT INTO Inventory VALUES (11,9,56601, 273); INSERT INTO Inventory VALUES (11,13,45622,231); INSERT INTO Inventory VALUES (12,1,51850,104); INSERT INTO Inventory VALUES (12,3,19316,280); INSERT INTO Inventory VALUES (12,5,61826,105); INSERT INTO Inventory VALUES (13,4,76716,236); INSERT INTO Inventory VALUES (13,11,39984, 70); INSERT INTO Inventory VALUES (14,1,15732, 9); INSERT INTO Inventory VALUES (14,6,3927,162); INSERT INTO Inventory VALUES (14,10, 36477,208); INSERT INTO Inventory VALUES (16,8,54379, 10); INSERT INTO Inventory VALUES (16,14,25376, 39); INSERT INTO Inventory VALUES (16,15, 69507,242); INSERT INTO Inventory VALUES (17,4,3119,153); INSERT INTO Inventory VALUES (17,9,78114,175); INSERT INTO Inventory VALUES (18,11,67869,296); INSERT INTO Inventory VALUES (19,2, 60605,238); INSERT INTO Inventory VALUES (19,4,11792,130); SERT INTO Inventory VALU (19,11,79557,83); INSERT INTO Inventory VALUES (20,2,3742,284); INSERT INTO Inventory VALUES (20,3,52831,38); INSERT INTO Inventory VALUES (20,7,26176,260); INSERT INTO Inventory VALUES (22,6,10464,190); INSERT INTO Inventory VALUES (22,11,17534,145); INSERT INTO Inventory VALUES (22,12,74204, 99);
INSERT INTO Inventory VALUES (23,1,1378,228); INSERT INTO Inventory VALUES (23,9,18051,176); INSERT INTO Inventory VALUES (24,9,58107,86); INSERT INTO Inventory VALUES (24,14,55023,241); INSERT INTO Inventory VALUES (25,13,76431,178); INSERT INTO Inventory VALUES (26,4,32433,240); INSERT INTO Inventory VALUES (26,6,41866,168); INSERT INTO Inventory VALUES (26,7,40360, 43); INSERT INTO Inventory VALUES (26,13,15086, 29); INSERT INTO Inventory VALUES (27,14,53721,190); INSERT INTO Inventory VALUES (28,9, 64143,89); INSERT INTO Inventory VALUES (29,2,48676,59); INSERT INTO Inventory VALUES (29,4,39702,285); INSERT INTO Inventory VALUES (30, 11, 60977, 6); INSERT INTO Inventory VALUES (30,13,46667,173); INSERT INTO Inventory VALUES (32,3,70469,283); INSERT INTO Inventory VALUES (33,2,11071,259); INSERT INTO Inventory VALUES (34,5,37259,268); INSERT INTO Inventory VALUES (34,9, 63551,228); INSERT INTO Inventory VALUES (34,12,54677,133); INSERT INTO Inventory VALUES (34,13,69932, 26); INSERT INTO Inventory VALUES (35,11, 60792, 291); INSERT INTO Inventory VALUES (39,6,53384,162); INSERT INTO Inventory VALUES (40,8,43143,180); INSERT INTO Inventory VALUES (40, 12, 32593, 135); INSERT INTO Inventory VALUES (40,13, 48539,246); INSERT INTO Inventory VALUES (40,15, 46385, 32); INSERT INTO Inventory VALUES (41,1,7502,213); INSERT INTO Inventory VALUES (42,9, 77941, 7); INSERT INTO Inventory VALUES (42,11,8391,140); INSERT INTO Inventory VALUES (44,14,13096, 23); INSERT INTO Inventory VALUES (45,14,15558,69); INSERT INTO Inventory VALUES (46,3,53420, 44); INSERT INTO Inventory VALUES (46,14, 9291,108); INSERT INTO Inventory VALUES (46,15,36646, 21); INSERT INTO Inventory VALUES (47,7,47288,106); INSERT INTO Inventory VALUES (47,8,33827,187); INSERT INTO Inventory VALUES (47,13,8734,283); INSERT INTO Inventory VALUES (48,12,9814,195); INSERT INTO Inventory VALUES (48,13,15767, 75); INSERT INTO Inventory VALUES (49, 6, 6170,126); INSERT INTO Inventory VALUES (49,11, 67085,254); INSERT INTO Inventory VALUES (49,13,6651,283); INSERT INTO Inventory VALUES (51,2,63638,253); INSERT INTO Inventory VALUES (51,3,69300,155); INSERT INTO Inventory VALUES (51,4,56939, 72); INSERT INTO Inventory VALUES (51,6,7585,45); INSERT INTO Inventory VALUES (51,11,77873,48); INSERT INTO Inventory VALUES (52,4,17065,197); INSERT INTO Inventory VALUES (52,11, 69333, 139); INSERT INTO Inventory VALUES (52,14, 78206,140); INSERT INTO Inventory VALUES (53,8,23502,258); INSERT INTO Inventory VALUES (53,10,11801,124); INSERT INTO Inventory VALUES (53,11,1457,104);
INSERT INTO Inventory VALUES (53,14,30928,198); INSERT INTO Inventory VALUES (54,7,37275,178); INSERT INTO Inventory VALUES (54,15,17916,285); INSERT INTO Inventory VALUES (55,4,78691,211); INSERT INTO Inventory VALUES (55,11, 65329,41); INSERT INTO Inventory VALUES (55,15,44326,157); INSERT INTO Inventory VALUES (57,8,15131,248); INSERT INTO Inventory VALUES (57,9,4736, 228); INSERT INTO Inventory VALUES (58,2,4618, 220); INSERT INTO Inventory VALUES (59,5,69811,139); INSERT INTO Inventory VALUES (59,9,40376,52); INSERT INTO Inventory VALUES (59,12, 57503, 138); INSERT INTO Inventory VALUES (59,13,76446, 85); INSERT INTO Inventory VALUES (60,3,69822,295); INSERT INTO Inventory VALUES (61, 6, 63666,10); INSERT INTO Inventory VALUES (61,7,45306,297); INSERT INTO Inventory VALUES (62,13, 69272, 109); INSERT INTO Inventory VALUES (63,15, 24622, 76); INSERT INTO Inventory VALUES (64, 14, 7099,90); INSERT INTO Inventory VALUES (65,4,13864, 52); INSERT INTO Inventory VALUES (66,13,23175,250); INSERT INTO Inventory VALUES (67,1, 68884,155); INSERT INTO Inventory VALUES (67,7,1637,205); INSERT INTO Inventory VALUES (67,8,37741,104); INSERT INTO Inventory VALUES (67,13,28347,236); INSERT INTO Inventory VALUES (68,1,21548,275); INSERT INTO Inventory VALUES (70,15, 47121, 230); INSERT INTO Inventory VALUES (71,9,7485,222); INSERT INTO Inventory VALUES (71,11,54859,106); INSERT INTO Inventory VALUES (74,1, 67279,200); INSERT INTO Inventory VALUES (74,5,66801,299); INSERT INTO Inventory VALUES (74,9,22799,107); INSERT INTO Inventory VALUES (74,15, 27628, 27); INSERT INTO Inventory VALUES (75,13, 4750, 63); INSERT INTO Inventory VALUES (76,2,29230,64); INSERT INTO Inventory VALUES (76,15,10721,101); INSERT INTO Inventory VALUES (77,6,46580, 67); INSERT INTO Inventory VALUES (77,8,59175, 255); INSERT INTO Inventory VALUES (78,4,3997, 78); INSERT INTO Inventory VALUES (78,6,13544,151); INSERT INTO Inventory VALUES (79,7,78785,228); INSERT INTO Inventory VALUES (80,5,27863, 92); INSERT INTO Inventory VALUES (80, 11, 30148, 26); INSERT INTO Inventory VALUES (80,13,15315, 274); INSERT INTO Inventory VALUES (81,2, 40477,151); INSERT INTO Inventory VALUES (81,7,70931,270); INSERT INTO Inventory VALUES (81,9,15761,126); INSERT INTO Inventory VALUES (81, 12, 72786, 237); INSERT INTO Inventory VALUES (81,13,14260,87); INSERT INTO Inventory VALUES (82,1,59375,123); INSERT INTO Inventory VALUES (82,7,16705,190); INSERT INTO Inventory VALUES (85, 14, 64322,195); INSERT INTO Inventory VALUES (88,9,22295,90); INSERT INTO Inventory VALUES (88,10,55077,88);
INSERT INTO Inventory VALUES (88,15,9576,178); INSERT INTO Inventory VALUES (89,7,71164,38); INSERT INTO Inventory VALUES (89,12,5251,18); INSERT INTO Inventory VALUES (90,9,76038,238); INSERT INTO Inventory VALUES (90,13, 66225,86); INSERT INTO Inventory VALUES (91,2,24498,147); INSERT INTO Inventory VALUES (91,9, 9866, 6); INSERT INTO Inventory VALUES (92,3,34596,179); INSERT INTO Inventory VALUES (92,6,54674,107); INSERT INTO Inventory VALUES (93,3,27528,144); INSERT INTO Inventory VALUES (93,6,14063,17); INSERT INTO Inventory VALUES (93,12,48989, 110); INSERT INTO Inventory VALUES (93,13, 38206, 288); INSERT INTO Inventory VALUES (94,6,19460,177); INSERT INTO Inventory VALUES (94,8,38868,30); INSERT INTO Inventory VALUES (94, 9,32045, 231); INSERT INTO Inventory VALUES (95,7,29279,162); INSERT INTO Inventory VALUES (95,8,21653,222); INSERT INTO Inventory VALUES (95, 10, 71330,287); INSERT INTO Inventory VALUES (96,3,68864,3); INSERT INTO Inventory VALUES (96,5,67606,193); INSERT INTO Inventory VALUES (96,11,6290, 215); INSERT INTO Inventory VALUES (96,15,76926,282); INSERT INTO Inventory VALUES (97,7,78164,16); INSERT INTO Inventory VALUES (97,8,72883,76); INSERT INTO Inventory VALUES (98,1, 60214,94); INSERT INTO Inventory VALUES (98,8, 60407,278); INSERT INTO Inventory VALUES (98,14, 14536,183); INSERT INTO Inventory VALUES (100, 6, 33737,166); INSERT INTO Inventory VALUES (100,7, 22208,89); INSERT INTO Inventory VALUES (101, 5, 79072, 34); INSERT INTO Inventory VALUES (101, 6, 61532,195); INSERT INTO Inventory VALUES (103, 6, 74524, 2); INSERT INTO Inventory VALUES (103, 9, 36869,123); INSERT INTO Inventory VALUES (103,13,79020,264); INSERT INTO Inventory VALUES (104, 6,10954,59); INSERT INTO Inventory VALUES (104, 10, 781,220); INSERT INTO Inventory VALUES (104,11,44223,259); INSERT INTO Inventory VALUES (105, 5, 9172, 38); INSERT INTO Inventory VALUES (105, 11,55487,292); INSERT INTO Inventory VALUES (105, 12,58175,191); INSERT INTO Inventory VALUES (105, 15,23454,262); INSERT INTO Inventory VALUES (106,12,5331, 138); INSERT INTO Inventory VALUES (108, 3, 62992, 71); INSERT INTO Inventory VALUES (109, 12, 4134,290); INSERT INTO Inventory VALUES (110,11,38821,288); INSERT INTO Inventory VALUES (111,2, 63716, 17); INSERT INTO Inventory VALUES (111,3,35616,124); INSERT INTO Inventory VALUES (111,10, 75097,50); INSERT INTO Inventory VALUES (111,14,12840,198); INSERT INTO Inventory VALUES (113,10,2702, 76); INSERT INTO Inventory VALUES (114,8,60508,229); INSERT INTO Inventory VALUES (114,15,6191,220); INSERT INTO Inventory VALUES (115, 3, 73956, 222);
INSERT INTO Inventory VALUES (115,9,28934, 245); INSERT INTO Inventory VALUES (117,4,28292,106); INSERT INTO Inventory VALUES (117,7,11443,193); INSERT INTO Inventory VALUES (119, 2, 38532,160); INSERT INTO Inventory VALUES (119,6,17697, 75); INSERT INTO Inventory VALUES (119,14,17876,106); INSERT INTO Inventory VALUES (120,5, 74000, 81); INSERT INTO Inventory VALUES (120, 6, 42692, 217); INSERT INTO Inventory VALUES (121, 1, 920, 289); INSERT INTO Inventory VALUES (122,5,16099, 91); INSERT INTO Inventory VALUES (122, 7, 54731, 231); INSERT INTO Inventory VALUES (122, 12,21639, 72); INSERT INTO Inventory VALUES (122,13,46075,253); INSERT INTO Inventory VALUES (123,2, 26326, 27); INSERT INTO Inventory VALUES (123,3, 20667,50); INSERT INTO Inventory VALUES (123,8,47539,193); INSERT INTO Inventory VALUES (123, 15,53057,127); INSERT INTO Inventory VALUES (124, 4, 12578, 75); INSERT INTO Inventory VALUES (124,7,3245, 92); INSERT INTO Inventory VALUES (124,14,74396,213); INSERT INTO Inventory VALUES (125, 4, 49008,116); INSERT INTO Inventory VALUES (125, 12,78364,36); INSERT INTO Inventory VALUES (125,14,61613,49); INSERT INTO Inventory VALUES (126, 3, 36620, 195); INSERT INTO Inventory VALUES (127,7,13878,261); INSERT INTO Inventory VALUES (127, 10,45970, 33); INSERT INTO Inventory VALUES (128, 2, 59115,94); INSERT INTO Inventory VALUES (128, 5, 75146, 2); INSERT INTO Inventory VALUES (129, 4, 31325, 241); INSERT INTO Inventory VALUES (130,2, 19562, 15); INSERT INTO Inventory VALUES (130,15,76615,180); INSERT INTO Inventory VALUES (131,5,73299,118); INSERT INTO Inventory VALUES (131, 10, 21629, 64); INSERT INTO Inventory VALUES (131, 11,66694,203); INSERT INTO Inventory VALUES (132, 8, 41460, 243); INSERT INTO Inventory VALUES (133, 5, 41012, 131); INSERT INTO Inventory VALUES (135, 10, 33804,58); INSERT INTO Inventory VALUES (135,14,29900,256); INSERT INTO Inventory VALUES (136, 6, 19384,150); INSERT INTO Inventory VALUES (136, 8, 53844, 185); INSERT INTO Inventory VALUES (136,10,2957,226); INSERT INTO Inventory VALUES (136,11,43325,20); INSERT INTO Inventory VALUES (137, 6, 79695,70); INSERT INTO Inventory VALUES (137,8,29158,164); INSERT INTO Inventory VALUES (137,15,18428,90); INSERT INTO Inventory VALUES (138,5,58384,294); INSERT INTO Inventory VALUES (138,12,77677,8); INSERT INTO Inventory VALUES (139,10,58859,260); INSERT INTO Inventory VALUES (140,11,31198,264); INSERT INTO Inventory VALUES (140, 12, 63769,258); INSERT INTO Inventory VALUES (142,3,24680, 212); INSERT INTO Inventory VALUES (142, 5, 70662,200); INSERT INTO Inventory VALUES (142, 8, 70599, 215); INSERT INTO Inventory VALUES (142,12,48603,273);
INSERT INTO Inventory VALUES (142,14,18606,175); INSERT INTO Inventory VALUES (142,15,33794,144); INSERT INTO Inventory VALUES (143,3,26330,173); INSERT INTO Inventory VALUES (144, 2, 79161,202); INSERT INTO Inventory VALUES (144,14,76666,104); INSERT INTO Inventory VALUES (146, 10,46892,114); INSERT INTO Inventory VALUES (146, 14,7439,95); INSERT INTO Inventory VALUES (147, 6, 42168, 77); INSERT INTO Inventory VALUES (147, 10,39464,125); INSERT INTO Inventory VALUES (148, 6,17826, 200); INSERT INTO Inventory VALUES (150, 6, 47774,113); INSERT INTO Inventory VALUES (150, 10,7826, 215); INSERT INTO Inventory VALUES (150,13,54677,109); INSERT INTO Inventory VALUES (151, 15,56660,78); INSERT INTO Inventory VALUES (152, 8, 6549,75); INSERT INTO Inventory VALUES (152,11,44166,8); INSERT INTO Inventory VALUES (152,12,65298,156); INSERT INTO Inventory VALUES (153, 5, 69973, 236); INSERT INTO Inventory VALUES (153, 9,52622, 37); INSERT INTO Inventory VALUES (153, 15,26983, 4); INSERT INTO Inventory VALUES (154, 3, 70463,206); INSERT INTO Inventory VALUES (154, 11, 60067,211); INSERT INTO Inventory VALUES (156, 3, 72113, 10); INSERT INTO Inventory VALUES (157,2, 9319, 244); INSERT INTO Inventory VALUES (159, 4, 37809,192); INSERT INTO Inventory VALUES (159,8, 66904,234); INSERT INTO Inventory VALUES (159, 13,33264,180); INSERT INTO Inventory VALUES (160, 14, 43154,162); INSERT INTO Inventory VALUES (161,10,8057,178); INSERT INTO Inventory VALUES (162,2, 31100, 203); INSERT INTO Inventory VALUES (162,3,10659, 102); INSERT INTO Inventory VALUES (162, 9, 41624, 25); INSERT INTO Inventory VALUES (162, 12, 31187,117); INSERT INTO Inventory VALUES (162, 13, 25751, 19); INSERT INTO Inventory VALUES (163,1, 66116,103); INSERT INTO Inventory VALUES (163, 6, 66727,149); INSERT INTO Inventory VALUES (163, 9, 53405,16); INSERT INTO Inventory VALUES (164, 1, 46099,27); INSERT INTO Inventory VALUES (164, 12,37632,25); INSERT INTO Inventory VALUES (165,2,31545,175); INSERT INTO Inventory VALUES (165, 13,32442, 40); INSERT INTO Inventory VALUES (166, 10, 78100, 7); INSERT INTO Inventory VALUES (167,2,34791,3); INSERT INTO Inventory VALUES (167,5,29739,282); INSERT INTO Inventory VALUES (167, 14, 67558,253); INSERT INTO Inventory VALUES (167,15,19391,171); INSERT INTO Inventory VALUES (168,2,51942,130); INSERT INTO Inventory VALUES (168,7,29043, 38); INSERT INTO Inventory VALUES (168,12,9527, 40); INSERT INTO Inventory VALUES (169, 8, 72336,222); INSERT INTO Inventory VALUES (169,14,10631,288); INSERT INTO Inventory VALUES (170, 5, 45226,232); INSERT INTO Inventory VALUES (170,11,57674,82); INSERT INTO Inventory VALUES (171, 5, 67072, 241);
INSERT INTO Inventory VALUES (171,12,59547,116); INSERT INTO Inventory VALUES (171,14,61112,189); INSERT INTO Inventory VALUES (171, 15, 62914, 92); INSERT INTO Inventory VALUES (172, 9, 40586, 142); INSERT INTO Inventory VALUES (172,10,4249,157); INSERT INTO Inventory VALUES (172,13,53701,155); INSERT INTO Inventory VALUES (172, 14, 62800, 247); INSERT INTO Inventory VALUES (173, 1, 64299, 21); INSERT INTO Inventory VALUES (173, 8, 35518,283); INSERT INTO Inventory VALUES (173, 12,36319,226); INSERT INTO Inventory VALUES (173, 14,50362, 60); INSERT INTO Inventory VALUES (174, 8, 59003, 133); INSERT INTO Inventory VALUES (174, 9, 71165,281); INSERT INTO Inventory VALUES (174, 13, 40106,288); INSERT INTO Inventory VALUES (175, 14,9442,133); INSERT INTO Inventory VALUES (176,1,43186, 85); INSERT INTO Inventory VALUES (176,14,57494,13); INSERT INTO Inventory VALUES (177,5, 48603, 99); INSERT INTO Inventory VALUES (177,7, 3474, 49); INSERT INTO Inventory VALUES (178, 2, 60439, 101); INSERT INTO Inventory VALUES (179,1,22952,214); INSERT INTO Inventory VALUES (179, 5, 61101,282); INSERT INTO Inventory VALUES (179, 6, 61201, 123); INSERT INTO Inventory VALUES (179, 7, 43012, 283); INSERT INTO Inventory VALUES (180, 13, 3105, 93); INSERT INTO Inventory VALUES (181, 15, 64179, 60); INSERT INTO Inventory VALUES (182,3,10048, 15); INSERT INTO Inventory VALUES (182, 4, 3855,64); INSERT INTO Inventory VALUES (182, 14, 6330, 0); INSERT INTO Inventory VALUES (184, 10, 74500,221); INSERT INTO Inventory VALUES (185, 4, 39045,134); INSERT INTO Inventory VALUES (186,10,59814,278); INSERT INTO Inventory VALUES (187, 8, 79184,87); INSERT INTO Inventory VALUES (188,7,73686,50); INSERT INTO Inventory VALUES (189, 8, 54632,115); INSERT INTO Inventory VALUES (189, 15,57852,94); INSERT INTO Inventory VALUES (190, 2, 32119,216); INSERT INTO Inventory VALUES (190, 7, 34345, 74); INSERT INTO Inventory VALUES (190, 10, 31217,202); INSERT INTO Inventory VALUES (190, 11,24725,183); INSERT INTO Inventory VALUES (190, 12,10634, 20); INSERT INTO Inventory VALUES (191, 13, 51641,205); INSERT INTO Inventory VALUES (192, 7,55987, 170); INSERT INTO Inventory VALUES (192, 14, 8243, 299); INSERT INTO Inventory VALUES (193, 6, 10334,161); INSERT INTO Inventory VALUES (193, 7, 66981, 296); INSERT INTO Inventory VALUES (193,14,12380,123); INSERT INTO Inventory VALUES (195, 7,52726,27); INSERT INTO Inventory VALUES (195, 12, 6698, 43); INSERT INTO Inventory VALUES (196,8,74812,179); INSERT INTO Inventory VALUES (197,3,24894, 222); INSERT INTO Inventory VALUES (197, 4, 39101,146); INSERT INTO Inventory VALUES (197,10,13167,195); INSERT INTO Inventory VALUES (197,15,48323,28);
INSERT INTO Inventory VALUES (199, 11, 9107,90); INSERT INTO Inventory VALUES (199,15,74619,35); INSERT INTO Inventory VALUES (200,2, 43386,36); INSERT INTO Inventory VALUES (200, 7,22460,204); INSERT INTO Inventory VALUES (201, 14, 70528,250); INSERT INTO Inventory VALUES (202, 3,8449,135); INSERT INTO Inventory VALUES (202, 13, 47636,214); INSERT INTO Inventory VALUES (203,14,15864, 61); INSERT INTO Inventory VALUES (204, 1, 38070, 212); INSERT INTO Inventory VALUES (204, 5, 71096,154); INSERT INTO Inventory VALUES (205, 7, 19718, 44); INSERT INTO Inventory VALUES (206, 9, 36153,285); INSERT INTO Inventory VALUES (206, 13, 8171,209); INSERT INTO Inventory VALUES (206,15,2183, 294); INSERT INTO Inventory VALUES (207,5, 6398,73); INSERT INTO Inventory VALUES (207,10,48424,71); INSERT INTO Inventory VALUES (207,12,5610, 57); INSERT INTO Inventory VALUES (208,3, 23009, 187); INSERT INTO Inventory VALUES (208,10,15251,6); INSERT INTO Inventory VALUES (208,11,6117, 52); INSERT INTO Inventory VALUES (208, 14,558,103); INSERT INTO Inventory VALUES (209, 11,75702,139); INSERT INTO Inventory VALUES (209,13,11320,248); INSERT INTO Inventory VALUES (210,1, 71265, 37); INSERT INTO Inventory VALUES (210, 14,55043,139); INSERT INTO Inventory VALUES (211, 3, 47511, 231); INSERT INTO Inventory VALUES (211,10,41326,77); INSERT INTO Inventory VALUES (212, 3, 40592,139); INSERT INTO Inventory VALUES (212,13,16200,174); INSERT INTO Inventory VALUES (212,14,4129,294); INSERT INTO Inventory VALUES (213,7,18426, 33); INSERT INTO Inventory VALUES (214,3,27691,145); INSERT INTO Inventory VALUES (214, 5, 32489, 112); INSERT INTO Inventory VALUES (214,7, 36182, 123); INSERT INTO Inventory VALUES (214, 9, 16523,152); INSERT INTO Inventory VALUES (215, 4, 9140,197); INSERT INTO Inventory VALUES (215, 5, 26776, 139); INSERT INTO Inventory VALUES (215, 9, 7042,216); INSERT INTO Inventory VALUES (215,13,1978,124); INSERT INTO Inventory VALUES (216, 8, 15337,183); INSERT INTO Inventory VALUES (216,9,31632,163); INSERT INTO Inventory VALUES (216,10,47184,8); INSERT INTO Inventory VALUES (217,6,56420, 208); INSERT INTO Inventory VALUES (217,9,72854,175); INSERT INTO Inventory VALUES (217, 12, 39200,158); INSERT INTO Inventory VALUES (218,3, 23607,191); INSERT INTO Inventory VALUES (218,5, 72426,294); INSERT INTO Inventory VALUES (218,9,68643, 68); INSERT INTO Inventory VALUES (219,2,16296, 212); INSERT INTO Inventory VALUES (219, 3, 68079, 121); INSERT INTO Inventory VALUES (219,10,41564,232); INSERT INTO Inventory VALUES (219,11,23720,85); INSERT INTO Inventory VALUES (219,14,52606,240); INSERT INTO Inventory VALUES (220, 4, 69874, 34);
VALUES INSERT INTO Inventory VALUES (220, 7,78099,286); INSERT INTO Inventory VALUES (220, 14,79408,262); INSERT INTO Inventory VALUES (221, 6,5720,101); INSERT INTO Inventory (221,15,50513,158); INSERT INTO Inventory VALUES (222,3,69258,126); INSERT INTO Inventory VALUES (222, 7,26362, 292); INSERT INTO Inventory VALUES (223, 1, 45714, 79); INSERT INTO Inventory VALUES (224, 7, 40215, 257); INSERT INTO Inventory VALUES (224,12,27898,98); INSERT INTO Inventory VALUES (225, 5, 70895,16); INSERT INTO Inventory VALUES (225,8,21881,160); INSERT INTO Inventory VALUES (226, 2, 49087, 250); INSERT INTO Inventory VALUES (226,13,69893,130); INSERT INTO Inventory VALUES (227,1, 9350,298); INSERT INTO Inventory VALUES (227, 6, 79790, 253); INSERT INTO Inventory VALUES (227,10,47859,188); INSERT INTO Inventory VALUES (227,15,8628,147); INSERT INTO Inventory VALUES (228,1,13643,193); INSERT INTO Inventory VALUES (228,2,19577,119); INSERT INTO Inventory VALUES (229, 4, 67795,157); INSERT INTO Inventory VALUES (229,7,57448, 4); INSERT INTO Inventory VALUES (229, 12, 10242,282); INSERT INTO Inventory VALUES (230, 3, 10459, 237); INSERT INTO Inventory VALUES (230, 4, 38707,245); INSERT INTO Inventory VALUES (230,9,2868,14); INSERT INTO Inventory VALUES (231, 4, 32975, 172); INSERT INTO Inventory VALUES (231, 5, 71790, 234); INSERT INTO Inventory VALUES (232, 7, 78189, 291); INSERT INTO Inventory VALUES (233, 8, 64814, 85); INSERT INTO Inventory VALUES (233,10,45812,153); INSERT INTO Inventory VALUES (235, 3, 34504, 185); INSERT INTO Inventory VALUES (236, 1,9448, 21); INSERT INTO Inventory VALUES (236, 2, 68735, 134); INSERT INTO Inventory VALUES (236,14,52497,248); INSERT INTO Inventory VALUES (238, 6, 6408,258); INSERT INTO Inventory VALUES (239, 15, 56392, 125); INSERT INTO Inventory VALUES (240, 2,76760, 269); INSERT INTO Inventory VALUES (240, 3, 63197, 107); INSERT INTO Inventory VALUES (240, 5, 28765,148); INSERT INTO Inventory VALUES (240,9, 46276,28); INSERT INTO Inventory VALUES (240,14,6166,200); INSERT INTO Inventory VALUES (241, 13, 15949,190); INSERT INTO Inventory VALUES (244, 2, 44338,147); INSERT INTO Inventory VALUES (244, 5, 53215, 239); INSERT INTO Inventory VALUES (244,7,31699,110); INSERT INTO Inventory VALUES (244, 9, 26429, 145); INSERT INTO Inventory VALUES (245, 7,52346, 255); INSERT INTO Inventory VALUES (245,15,22180,22); INSERT INTO Inventory VALUES (247,9,35187,282); INSERT INTO Inventory VALUES (247,11,77479,29); INSERT INTO Inventory VALUES (248,3,68558,289); INSERT INTO Inventory VALUES (248, 15, 63655,130); INSERT INTO Inventory VALUES (249,1,56347,82); INSERT INTO Inventory VALUES (249, 5, 38610, 56);
INSERT INTO Inventory VALUES (249,7,8375,130); INSERT INTO Inventory VALUES (250, 3, 30218, 34); INSERT INTO Inventory VALUES (250, 4, 36622, 11); INSERT INTO Inventory VALUES (251, 10, 28385, 12); INSERT INTO Inventory VALUES (251,13,74048,209); INSERT INTO Inventory VALUES (252,10,55631, 32); INSERT INTO Inventory VALUES (253, 9, 75950, 33); INSERT INTO Inventory VALUES (255,14,23172,294); INSERT INTO Inventory VALUES (256, 8, 78785, 61); INSERT INTO Inventory VALUES (256, 12, 37353, 71); INSERT INTO Inventory VALUES (256,14,78687,73); INSERT INTO Inventory VALUES (257, 5, 53618, 115); INSERT INTO Inventory VALUES (257,15,75969,248); INSERT INTO Inventory VALUES (258,3, 2393,161); INSERT INTO Inventory VALUES (258, 6, 65935, 271); INSERT INTO Inventory VALUES (258,11,21597,116); INSERT INTO Inventory VALUES (258,12,17826,109); INSERT INTO Inventory VALUES (259,12,19040,214); INSERT INTO Inventory VALUES (260, 7,41137, 78); INSERT INTO Inventory VALUES (262, 5, 73303, 184); INSERT INTO Inventory VALUES (262,14,76420,86); INSERT INTO Inventory VALUES (264, 8, 79569,234); INSERT INTO Inventory VALUES (264, 11, 61508,156); INSERT INTO Inventory VALUES (266, 2,961,180); INSERT INTO Inventory VALUES (266, 7, 79095,172); INSERT INTO Inventory VALUES (266,11,25632,267); INSERT INTO Inventory VALUES (267,1,28419, 228); INSERT INTO Inventory VALUES (267, 6, 73616, 267); INSERT INTO Inventory VALUES (268, 7, 63781, 22); INSERT INTO Inventory VALUES (268, 14, 6036, 4); INSERT INTO Inventory VALUES (270,8,71862,148); INSERT INTO Inventory VALUES (270,11,27971,282); INSERT INTO Inventory VALUES (271,10,45837,86); INSERT INTO Inventory VALUES (272, 4, 67561, 2); INSERT INTO Inventory VALUES (272,5, 76797, 36); INSERT INTO Inventory VALUES (272,10,37403,55); INSERT INTO Inventory VALUES (273,1, 32464, 75); INSERT INTO Inventory VALUES (273,2,3124, 227); INSERT INTO Inventory VALUES (275,14,72480, 189); INSERT INTO Inventory VALUES (275, 15, 53218,138); INSERT INTO Inventory VALUES (276,2,13211,127); INSERT INTO Inventory VALUES (276, 4, 30523,97); INSERT INTO Inventory VALUES (276, 9,23482, 77); INSERT INTO Inventory VALUES (276,11,42908,46); INSERT INTO Inventory VALUES (276,14,31010,82); INSERT INTO Inventory VALUES (277,2, 31601, 15); INSERT INTO Inventory VALUES (277,12,76981,15); INSERT INTO Inventory VALUES (278,2,8561,279); INSERT INTO Inventory VALUES (278,6,5875,154); INSERT INTO Inventory VALUES (279,4,73272,86); INSERT INTO Inventory VALUES (279,14,22947,58); INSERT INTO Inventory VALUES (280, 2, 35986, 165); INSERT INTO Inventory VALUES (280, 10, 63096,175); INSERT INTO Inventory VALUES (281,5, 56993, 62);
INSERT INTO Inventory VALUES (281, 6,36289,37); INSERT INTO Inventory VALUES (281,9,4728,228); INSERT INTO Inventory VALUES (281,13,33292,101); INSERT INTO Inventory VALUES (282, 1, 21430,237); INSERT INTO Inventory VALUES (282, 4, 61914,190); INSERT INTO Inventory VALUES (282,12,47331,36); INSERT INTO Inventory VALUES (283, 6, 36385, 30); INSERT INTO Inventory VALUES (284,10,63807,127); INSERT INTO Inventory VALUES (284,13,56012,159); INSERT INTO Inventory VALUES (284, 14, 74394,218); INSERT INTO Inventory VALUES (285,15,37345,99); INSERT INTO Inventory VALUES (286, 9, 20774,54); INSERT INTO Inventory VALUES (286,10,2555, 26); INSERT INTO Inventory VALUES (287,5, 18166,82); INSERT INTO Inventory VALUES (288, 2, 72854, 225); INSERT INTO Inventory VALUES (288,5,8442,242); INSERT INTO Inventory VALUES (289, 7, 45430, 31); INSERT INTO Inventory VALUES (290, 5, 42219,156); INSERT INTO Inventory VALUES (290, 8, 79270, 125); INSERT INTO Inventory VALUES (291, 2,55083, 7); INSERT INTO Inventory VALUES (291,4,64272, 272); INSERT INTO Inventory VALUES (293,8,58233, 67); INSERT INTO Inventory VALUES (297, 4, 36314, 40); INSERT INTO Inventory VALUES (297,5, 45738,249); INSERT INTO Inventory VALUES (299, 9, 50658,212); INSERT INTO Inventory VALUES (299,12,16551,186); INSERT INTO Inventory VALUES (300, 3, 38899,207); INSERT INTO Inventory VALUES (301, 2, 73513,129); INSERT INTO Inventory VALUES (301, 14,5084,99); INSERT INTO Inventory VALUES (302, 7, 21872,180); INSERT INTO Inventory VALUES (302,13,28254, 22); INSERT INTO Inventory VALUES (303,2, 73122, 194); INSERT INTO Inventory VALUES (303, 7,55090, 74); INSERT INTO Inventory VALUES (304, 1, 34635, 7); INSERT INTO Inventory VALUES (305, 12,30694,277); INSERT INTO Inventory VALUES (307,2,17455, 212); INSERT INTO Inventory VALUES (307, 10,58829,78); INSERT INTO Inventory VALUES (307,12,37414,198); INSERT INTO Inventory VALUES (307,14,4594,112); INSERT INTO Inventory VALUES (307, 15, 32201,134); INSERT INTO Inventory VALUES (308, 3, 76498,162); INSERT INTO Inventory VALUES (308,14,19673,170); INSERT INTO Inventory VALUES (309,11,5688, 38); INSERT INTO Inventory VALUES (309,14,7293,64); INSERT INTO Inventory VALUES (311, 9, 20377, 62); INSERT INTO Inventory VALUES (311,13,55950,288); INSERT INTO Inventory VALUES (311,14,47394,179); INSERT INTO Inventory VALUES (312, 6, 48566,251); INSERT INTO Inventory VALUES (313,2,34801, 46); INSERT INTO Inventory VALUES (313, 12,77157,92); INSERT INTO Inventory VALUES (314,5,55842,266); INSERT INTO Inventory VALUES (314, 7, 70502,27); INSERT INTO Inventory VALUES (314,8, 26289,162); INSERT INTO Inventory VALUES (315,3,17937,199);
INSERT INTO Inventory VALUES (316,8,40812,144); INSERT INTO Inventory VALUES (316,10,2529,125); INSERT INTO Inventory VALUES (316,12,34671,155); INSERT INTO Inventory VALUES (317,6,56773,264); INSERT INTO Inventory VALUES (317,8,29204,117); INSERT INTO Inventory VALUES (317,12,13206, 73); INSERT INTO Inventory VALUES (318, 2, 22545, 117); INSERT INTO Inventory VALUES (318,15,44217,106); INSERT INTO Inventory VALUES (319, 2,70084,279); INSERT INTO Inventory VALUES (319,4,77871,88); INSERT INTO Inventory VALUES (320,9, 77806,18); INSERT INTO Inventory VALUES (320,13,5347,164); INSERT INTO Inventory VALUES (321, 5, 9201,265); INSERT INTO Inventory VALUES (321, 10, 7375, 236); INSERT INTO Inventory VALUES (321, 13,57825,257); INSERT INTO Inventory VALUES (323, 4, 23883, 34); INSERT INTO Inventory VALUES (325,11,56332,0); INSERT INTO Inventory VALUES (326,2, 54989,266); INSERT INTO Inventory VALUES (326,15,49244,58); INSERT INTO Inventory VALUES (327,12,6117,124); INSERT INTO Inventory VALUES (328,11,60300,108); INSERT INTO Inventory VALUES (328,14,43712,1); INSERT INTO Inventory VALUES (329, 2, 54209, 189); INSERT INTO Inventory VALUES (329, 5, 67252, 252); INSERT INTO Inventory VALUES (329,13,24761,181); INSERT INTO Inventory VALUES (330, 4, 73405, 89); INSERT INTO Inventory VALUES (330, 9, 75831, 197); INSERT INTO Inventory VALUES (330,11,20471, 15); INSERT INTO Inventory VALUES (330, 15,50158,292); INSERT INTO Inventory VALUES (331, 13,34714,177); INSERT INTO Inventory VALUES (332,2, 52910, 53); INSERT INTO Inventory VALUES (332, 3, 9753,219); INSERT INTO Inventory VALUES (332, 5, 73492, 99); INSERT INTO Inventory VALUES (332, 12, 75126,172); INSERT INTO Inventory VALUES (334, 5,50084, 135); INSERT INTO Inventory VALUES (334, 6, 75546,139); INSERT INTO Inventory VALUES (334,14,19149,167); INSERT INTO Inventory VALUES (336, 6, 31182, 121); INSERT INTO Inventory VALUES (337, 1, 13439, 96); INSERT INTO Inventory VALUES (337,2, 26107, 45); INSERT INTO Inventory VALUES (338, 3,59968, 39); INSERT INTO Inventory VALUES (338,11,52513, 74); INSERT INTO Inventory VALUES (339, 1, 58572, 165); INSERT INTO Inventory VALUES (339, 3, 37591,131); INSERT INTO Inventory VALUES (339, 9, 34517,243); INSERT INTO Inventory VALUES (339,14,15511,245); INSERT INTO Inventory VALUES (340, 2, 39120,95); INSERT INTO Inventory VALUES (340,11,23117,206); INSERT INTO Inventory VALUES (340,12,34675,59); INSERT INTO Inventory VALUES (341,4,62634,139); INSERT INTO Inventory VALUES (342,1, 65702, 78); INSERT INTO Inventory VALUES (342,5, 63441,245); INSERT INTO Inventory VALUES (342,8,16790,149); INSERT INTO Inventory VALUES (343, 4, 47140,191);
INSERT INTO Inventory VALUES (343,9,43728,161); INSERT INTO Inventory VALUES (343,12,57131,229); INSERT INTO Inventory VALUES (345,15,41657, 2); INSERT INTO Inventory VALUES (346,4,14919,231); INSERT INTO Inventory VALUES (346,10,62401,252); INSERT INTO Inventory VALUES (346,15,15277,36); INSERT INTO Inventory VALUES (347,7,50716, 31); INSERT INTO Inventory VALUES (348,2,45273,172); INSERT INTO Inventory VALUES (348, 3, 43221,199); INSERT INTO Inventory VALUES (348, 4, 6521,235); INSERT INTO Inventory VALUES (348,11,71761,289); INSERT INTO Inventory VALUES (348,15,75720,70); INSERT INTO Inventory VALUES (349, 2, 39011, 3); INSERT INTO Inventory VALUES (350, 7, 19466,209); INSERT INTO Inventory VALUES (350,12,40762,296); INSERT INTO Inventory VALUES (350, 14, 47609,5); INSERT INTO Inventory VALUES (350, 15, 31295,138); INSERT INTO Inventory VALUES (351, 3, 24562, 219); INSERT INTO Inventory VALUES (352, 1,76862,45); INSERT INTO Inventory VALUES (352, 2, 15017, 269); INSERT INTO Inventory VALUES (352, 3, 60484, 57); INSERT INTO Inventory VALUES (353, 5, 62215,1); INSERT INTO Inventory VALUES (353,12,12891,109); INSERT INTO Inventory VALUES (354, 4, 32082, 172); INSERT INTO Inventory VALUES (354,7,37797,257); INSERT INTO Inventory VALUES (355, 7,24716,132); INSERT INTO Inventory VALUES (356,15,36499,128); INSERT INTO Inventory VALUES (357, 5, 7597,200); INSERT INTO Inventory VALUES (357,14,52927,25); INSERT INTO Inventory VALUES (358, 1, 28500, 94); INSERT INTO Inventory VALUES (358,13,56984,263); INSERT INTO Inventory VALUES (359, 15, 62881,217); INSERT INTO Inventory VALUES (360,2, 39801, 117); INSERT INTO Inventory VALUES (360, 3, 33171, 38); INSERT INTO Inventory VALUES (360, 9,44069,108); INSERT INTO Inventory VALUES (360,10,54406,146); INSERT INTO Inventory VALUES (360,15,17147, 255); INSERT INTO Inventory VALUES (361, 2,52877,253); INSERT INTO Inventory VALUES (361, 4, 77180, 288); INSERT INTO Inventory VALUES (361,12,65661,194); INSERT INTO Inventory VALUES (361, 13,5592,193); INSERT INTO Inventory VALUES (363,2,33850,143); INSERT INTO Inventory VALUES (363, 6, 79909, 243); INSERT INTO Inventory VALUES (363,8, 6401,171); INSERT INTO Inventory VALUES (364,13,5825,285); INSERT INTO Inventory VALUES (365,1, 9261,125); INSERT INTO Inventory VALUES (365, 6, 3738,133); SERT INTO Inventory VALUES (365, 9, 78489,188); INSERT INTO Inventory VALUES (365,11,78056,40); INSERT INTO Inventory VALUES (366, 2, 73955,209); INSERT INTO Inventory VALUES (366, 3,54240,237); INSERT INTO Inventory VALUES (366,5, 38011, 218); INSERT INTO Inventory VALUES (366, 15, 63374,98); INSERT INTO Inventory VALUES (367,10,38266,231);
INSERT INTO Inventory VALUES (367,13,43377,109); INSERT INTO Inventory VALUES (367,14,11451,257); INSERT INTO Inventory VALUES (367,15,53985, 244); INSERT INTO Inventory VALUES (368,10,19721,251); INSERT INTO Inventory VALUES (369,11,51644,277); INSERT INTO Inventory VALUES (370, 3, 16455,185); INSERT INTO Inventory VALUES (370, 7, 60349,142); INSERT INTO Inventory VALUES (370,12,14225,206); INSERT INTO Inventory VALUES (371, 6, 11245,37); INSERT INTO Inventory VALUES (371,15,35756,286); INSERT INTO Inventory VALUES (373,1, 6026, 65); INSERT INTO Inventory VALUES (374, 7, 48652, 262); INSERT INTO Inventory VALUES (375, 9, 43893, 186); INSERT INTO Inventory VALUES (375,11,57308,38); INSERT INTO Inventory VALUES (376, 1, 4183, 53); INSERT INTO Inventory VALUES (376,2, 59262, 69); INSERT INTO Inventory VALUES (377,8, 22501, 193); INSERT INTO Inventory VALUES (377,12,18977, 60); INSERT INTO Inventory VALUES (377,14,24947,272); INSERT INTO Inventory VALUES (378,9,49778,187); INSERT INTO Inventory VALUES (378,13,36966,287); INSERT INTO Inventory VALUES (379, 9, 26395, 38); INSERT INTO Inventory VALUES (382, 1,74982,213); INSERT INTO Inventory VALUES (382,2, 47021,169); INSERT INTO Inventory VALUES (382, 15, 40366,133); INSERT INTO Inventory VALUES (383, 7, 64435, 120); INSERT INTO Inventory VALUES (383, 8,29730, 256); INSERT INTO Inventory VALUES (383,12, 60896,214); INSERT INTO Inventory VALUES (384, 9, 49733, 89); INSERT INTO Inventory VALUES (384, 15, 48799,176); INSERT INTO Inventory VALUES (385, 7,22578,230); INSERT INTO Inventory VALUES (385,13,3361, 251); INSERT INTO Inventory VALUES (386, 1, 31298,164); INSERT INTO Inventory VALUES (386,10,67294,100); INSERT INTO Inventory VALUES (387, 1, 10245, 115); INSERT INTO Inventory VALUES (388,2,54370,270); INSERT INTO Inventory VALUES (388,4, 23454,220); INSERT INTO Inventory VALUES (388,13,53208,118); INSERT INTO Inventory VALUES (388, 14, 65392,204); INSERT INTO Inventory VALUES (389, 8, 6209,273); INSERT INTO Inventory VALUES (391,2,31020, 190); INSERT INTO Inventory VALUES (391, 3, 6034,288); INSERT INTO Inventory VALUES (391, 6, 10832, 130); INSERT INTO Inventory VALUES (391,15,79679,84); INSERT INTO Inventory VALUES (396, 7, 46103,192); INSERT INTO Inventory VALUES (397,2,35825, 40); INSERT INTO Inventory VALUES (398,5,6973,114); SERT INTO Inventory VALUES (398, 7, 11288,146); INSERT INTO Inventory VALUES (398, 12,53605,118); INSERT INTO Inventory VALUES (398, 14, 63973,119); INSERT INTO Inventory VALUES (399, 3, 35016, 288); INSERT INTO Inventory VALUES (400,1,33895,84); INSERT INTO Inventory VALUES (400, 12, 43100,194); INSERT INTO Inventory VALUES (401,5,10310,80);
INSERT INTO Inventory VALUES (401,10,20211,134); INSERT INTO Inventory VALUES (401,13,13601,113); INSERT INTO Inventory VALUES (402,1,73555,274); INSERT INTO Inventory VALUES (402,11,25725,70); INSERT INTO Inventory VALUES (402,15,68337,139); INSERT INTO Inventory VALUES (405,1, 4136,191); INSERT INTO Inventory VALUES (405, 6, 32057, 37); INSERT INTO Inventory VALUES (406,2,20624,188); INSERT INTO Inventory VALUES (406, 5, 52411,230); INSERT INTO Inventory VALUES (406, 12, 67918, 22); INSERT INTO Inventory VALUES (407,1,20713, 227); INSERT INTO Inventory VALUES (407, 9, 57914,270); INSERT INTO Inventory VALUES (407,11,68331,190); INSERT INTO Inventory VALUES (408, 6, 34097,147); INSERT INTO Inventory VALUES (408,8,35885, 126); INSERT INTO Inventory VALUES (410,1,5963,223); INSERT INTO Inventory VALUES (410,10,53431,107); INSERT INTO Inventory VALUES (410, 12,35982,164); INSERT INTO Inventory VALUES (410,13,76775,287); INSERT INTO Inventory VALUES (411, 15,57656,148); INSERT INTO Inventory VALUES (412, 5, 26301,259); INSERT INTO Inventory VALUES (413,10,21645,262); INSERT INTO Inventory VALUES (413,13,56644,181); INSERT INTO Inventory VALUES (414, 5, 6689, 225); INSERT INTO Inventory VALUES (414, 7, 20173, 137); INSERT INTO Inventory VALUES (414, 13, 71022,264); INSERT INTO Inventory VALUES (414, 15, 35794,196); INSERT INTO Inventory VALUES (415,1,39662,156); INSERT INTO Inventory VALUES (415, 8, 3256,210); INSERT INTO Inventory VALUES (415, 12, 12570,221); INSERT INTO Inventory VALUES (416,6,10812, 228); INSERT INTO Inventory VALUES (416,7,19705,243); INSERT INTO Inventory VALUES (416,8,13877,154); INSERT INTO Inventory VALUES (416,11,30773,169); INSERT INTO Inventory VALUES (417,15,29567,284); INSERT INTO Inventory VALUES (418,3,18414,194); INSERT INTO Inventory VALUES (418,12,76490,47); INSERT INTO Inventory VALUES (419,5,12995, 221); INSERT INTO Inventory VALUES (419,11,32167,255); INSERT INTO Inventory VALUES (419,14,52623, 72); INSERT INTO Inventory VALUES (420,9,50776, 0); INSERT INTO Inventory VALUES (420, 12, 7564, 286); INSERT INTO Inventory VALUES (420, 14,4870,297); INSERT INTO Inventory VALUES (421,9, 65203,111); INSERT INTO Inventory VALUES (422, 4, 72301, 80); INSERT INTO Inventory VALUES (422, 6, 59835, 31); INSERT INTO Inventory VALUES (423,10,2946, 224); SERT INTO Inventory VALUES (423, 15, 40127,94); INSERT INTO Inventory VALUES (424,7,6243,190); INSERT INTO Inventory VALUES (424,14,59784,69); INSERT INTO Inventory VALUES (425,5,23221, 61); INSERT INTO Inventory VALUES (426,6,66192, 20); INSERT INTO Inventory VALUES (427, 4,16156, 229); INSERT INTO Inventory VALUES (429,5,67672,132);
INSERT INTO Inventory VALUES (429,8,35146,219); INSERT INTO Inventory VALUES (430, 2, 68435,81); INSERT INTO Inventory VALUES (430, 4,27440,169); INSERT INTO Inventory VALUES (430, 7, 79855, 56); INSERT INTO Inventory VALUES (431,10,11333,67); INSERT INTO Inventory VALUES (432, 7, 5270,229); INSERT INTO Inventory VALUES (433,2,56071,183); INSERT INTO Inventory VALUES (433, 3, 8490,265); INSERT INTO Inventory VALUES (433,4,59933, 96); INSERT INTO Inventory VALUES (433, 6, 4702,129); INSERT INTO Inventory VALUES (434, 1, 47038, 61); INSERT INTO Inventory VALUES (434,12,915,217); INSERT INTO Inventory VALUES (436, 2, 64528, 298); INSERT INTO Inventory VALUES (436, 9, 9288,161); INSERT INTO Inventory VALUES (438, 3, 61564, 102); INSERT INTO Inventory VALUES (439,5,11888,108); INSERT INTO Inventory VALUES (439,15,28132,10); INSERT INTO Inventory VALUES (442, 5, 64684,159); INSERT INTO Inventory VALUES (442,7, 4364,277); INSERT INTO Inventory VALUES (442, 9, 5160,278); INSERT INTO Inventory VALUES (443, 5, 75207, 235); INSERT INTO Inventory VALUES (443,9,13981, 282); INSERT INTO Inventory VALUES (443, 14, 61804,264); INSERT INTO Inventory VALUES (444, 4, 1014, 46); INSERT INTO Inventory VALUES (444, 8, 65284,214); INSERT INTO Inventory VALUES (445,5,56407,193) ; INSERT INTO Inventory VALUES (445,6,71426,126); INSERT INTO Inventory VALUES (445, 8,54186,197); INSERT INTO Inventory VALUES (445, 10, 64669,5); INSERT INTO Inventory VALUES (445, 12, 72361, 120); INSERT INTO Inventory VALUES (446, 4, 34853, 72); INSERT INTO Inventory VALUES (446, 6, 19595, 42); INSERT INTO Inventory VALUES (446, 8, 63229,269); INSERT INTO Inventory VALUES (446, 9, 15138, 264); INSERT INTO Inventory VALUES (447,1, 8523, 54); INSERT INTO Inventory VALUES (447, 14,59686,219); INSERT INTO Inventory VALUES (448, 6, 37751,288); INSERT INTO Inventory VALUES (448, 9, 33805,180); INSERT INTO Inventory VALUES (448,15,75498,71¹); INSERT INTO Inventory VALUES (449, 4, 65864, 292); INSERT INTO Inventory VALUES (449, 6, 30747,210); INSERT INTO Inventory VALUES (449,12,32241,91); INSERT INTO Inventory VALUES (449, 15, 62704, 42); INSERT INTO Inventory VALUES (451, 4,25027,249); INSERT INTO Inventory VALUES (451,14,11581,125); INSERT INTO Inventory VALUES (452, 7, 42554,230); INSERT INTO Inventory VALUES (452, 8, 73984, 24); SERT INTO Inventory VALUES (454, 5, 62705,170); INSERT INTO Inventory VALUES (454, 6, 60009, 139); INSERT INTO Inventory VALUES (454, 7, 32511, 292); INSERT INTO Inventory VALUES (454,8,67769,153); INSERT INTO Inventory VALUES (455,7,19804,213); INSERT INTO Inventory VALUES (455,15,11608,88); INSERT INTO Inventory VALUES (456,7,7982,249);
INSERT INTO Inventory VALUES (456,8,35166, 13); INSERT INTO Inventory VALUES (457,1,5564,290); INSERT INTO Inventory VALUES (457,9,36595,28); INSERT INTO Inventory VALUES (458,4,5522,276); INSERT INTO Inventory VALUES (458, 15, 70236,216); INSERT INTO Inventory VALUES (459,14,71128,110); INSERT INTO Inventory VALUES (460,2,12684,232); INSERT INTO Inventory VALUES (460,5,59603,155); INSERT INTO Inventory VALUES (461,11,8885,106); INSERT INTO Inventory VALUES (462, 4, 72441, 213); INSERT INTO Inventory VALUES (462,11,55317,143); INSERT INTO Inventory VALUES (463,8,27947,283); INSERT INTO Inventory VALUES (463, 10, 35585,162); INSERT INTO Inventory VALUES (463,13,5285, 154); INSERT INTO Inventory VALUES (464, 6, 49089, 11); INSERT INTO Inventory VALUES (464, 9, 61687, 69); INSERT INTO Inventory VALUES (465,11,73860,192); INSERT INTO Inventory VALUES (466, 9, 51888,298); INSERT INTO Inventory VALUES (466,15,14107,131); INSERT INTO Inventory VALUES (467,1, 31114,297); INSERT INTO Inventory VALUES (467, 4, 52210, 83); INSERT INTO Inventory VALUES (467, 15, 21529,206); INSERT INTO Inventory VALUES (468,11,49560,188); INSERT INTO Inventory VALUES (468,12,4466,236); INSERT INTO Inventory VALUES (469,8,18291,59); INSERT INTO Inventory VALUES (469,10,38842,211); INSERT INTO Inventory VALUES (469,12,21898,235); INSERT INTO Inventory VALUES (469, 13, 67064,221); INSERT INTO Inventory VALUES (469,14,17031,150); INSERT INTO Inventory VALUES (470, 1, 50412, 208); INSERT INTO Inventory VALUES (470,3,7264,289); INSERT INTO Inventory VALUES (470, 6, 9600, 32); INSERT INTO Inventory VALUES (470,9, 30761, 287); INSERT INTO Inventory VALUES (470, 13,62225,192); INSERT INTO Inventory VALUES (473,2,26662, 123); INSERT INTO Inventory VALUES (473,8,17499, 232); INSERT INTO Inventory VALUES (473, 12, 65763,298); INSERT INTO Inventory VALUES (476, 6, 58706,112); INSERT INTO Inventory VALUES (476, 7,41389, 189); INSERT INTO Inventory VALUES (477,5, 23695,259); INSERT INTO Inventory VALUES (478,5,61771,143); INSERT INTO Inventory VALUES (478, 6, 62135,209); INSERT INTO Inventory VALUES (479,2, 9158,183); INSERT INTO Inventory VALUES (479, 3, 62815,243); INSERT INTO Inventory VALUES (479, 12,52815, 255); INSERT INTO Inventory VALUES (480, 6, 69425, 213); INSERT INTO Inventory VALUES (481, 2, 74460,80); SERT INTO Inventory VALUES (481, 9, 1215, 68); INSERT INTO Inventory VALUES (481,11,14710,300); INSERT INTO Inventory VALUES (482,10,10154,284); INSERT INTO Inventory VALUES (483,2,1463,163); INSERT INTO Inventory VALUES (483, 5, 45068,210); INSERT INTO Inventory VALUES (483,15,37076,37); INSERT INTO Inventory VALUES (484,2,52171,186);
INSERT INTO Inventory VALUES (484, 11, 62209,250); INSERT INTO Inventory VALUES (484,13,43454,6); INSERT INTO Inventory VALUES (484,14,43815,197); INSERT INTO Inventory VALUES (485, 4, 65955,104); INSERT INTO Inventory VALUES (486, 4, 43105, 116); INSERT INTO Inventory VALUES (487,2,13176,285); INSERT INTO Inventory VALUES (487,10,77616,13); INSERT INTO Inventory VALUES (489,5,68943,129); INSERT INTO Inventory VALUES (489,14,53507,38); INSERT INTO Inventory VALUES (490, 6, 29624,66); INSERT INTO Inventory VALUES (490, 9, 77382, 9); INSERT INTO Inventory VALUES (490,14,1973, 53); INSERT INTO Inventory VALUES (491,9, 15549, 3); INSERT INTO Inventory VALUES (491,13,76192,281); INSERT INTO Inventory VALUES (492, 3, 68634,158); INSERT INTO Inventory VALUES (492, 6, 13660, 290); INSERT INTO Inventory VALUES (492, 9, 39743, 223); INSERT INTO Inventory VALUES (494, 7,29920,283); INSERT INTO Inventory VALUES (495, 2, 41747,18); INSERT INTO Inventory VALUES (496, 10,39168,253); INSERT INTO Inventory VALUES (496,11,572,230); INSERT INTO Inventory VALUES (498, 4,75287,213); INSERT INTO Inventory VALUES (498,12,53255,90); INSERT INTO Inventory VALUES (499,2,1282,54); INSERT INTO Inventory VALUES (499, 4, 1799,268); INSERT INTO Inventory VALUES (500, 12, 8134, 258);
Instructions (Question 1 through 10): Step 1: the PostgreSQL sample database code file used in this assignment: Crete a
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am