Instructions (Question 1 through 10):
Step 1: the PostgreSQL sample database code file used in this assignment:
Crete a new database in PostgreSQL using the sample code file as shown in class (please remember NOT to copy the file's content directly from Canvas preview as it will not copy the statements correctly and the code may not work in PostgreSQL when pasted. Instead, download the text file first, open it, and then copy its content).
Step 2: Proceed to compose SQL statements to answer the queries posed in this assignment. Run the statements against the sample database in PostgreSQL. Make note of the results you obtain and compare it to the answers provided to help you find the right answer option for each question.
Question 3
What are the names of dealers who sell some black or yellow car?
Option 1: (CarsMax, MaxiCar, Carvana, CarsFast, Engines2Go, DriversFirst, WestCars, SouthMotors)
Option 2: (CarsMax, MaxiCar, SuperCars, LordOfCars, CarsUnited, Cars4All, BestCars, CarValue, FortCars, Carvana, CarsFast, Engines2Go, DriversFirst, WestCars, SouthMotors)
Option 3: (CarsMax, MaxiCar, SuperCars, LordOfCars, CarsUnited, Cars4All, BestCars, CarValue, FortCars, Carvana, CarsFast, Engines2Go, DriversFirst)
Option 4: (BestCars, Cars4All, CarsFast, CarsMax, CarsUnited, CarValue, Carvana, DriversFirst, Engines2Go, FortCars, MaxiCar, SouthMotors, WestCars)
Option 5: (BestCars, Cars4All, CarsFast, CarsMax, CarsUnited, CarValue, Carvana, DriversFirst, Engines2Go, FortCars, MaxiCar)
Option 6: (CarsMax, MaxiCar, SuperCars, LordOfCars, CarsUnited, Cars4All, BestCars)
Option 7: (Carvana, CarsFast, Engines2Go, DriversFirst, WestCars, SouthMotors)
Option 8: (BestCars, CarValue, FortCars, Carvana, CarsFast, Engines2Go)
Option 9: (CarsMax, MaxiCar, SuperCars, LordOfCars, CarsUnited, Cars4All, BestCars, CarValue, FortCars)
Option 10: (DriversFirst, WestCars, SouthMotors)
Group of answer choices
Option 1
Option 2
Option 3
Option 4
Option 5
Option 6
Option 7
Option 8
Option 9
Option 10
--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