INSERT INTO cylinders (cylinders) VALUES ('L4');
----------------------------------------------
INSERT INTO make (make) VALUES ('Buick');
INSERT INTO make (make) VALUES ('Chevrolet');
INSERT INTO make (make) VALUES ('Chrysler');
INSERT INTO make (make) VALUES ('Dodge');
INSERT INTO make (make) VALUES ('Hummer'); 
INSERT INTO make (make) VALUES ('Jeep');
INSERT INTO make (make) VALUES ('Ram');
INSERT INTO make (make) VALUES ('Saturn');
INSERT INTO make (make) VALUES ('Tesla');
INSERT INTO make (make) VALUES ('Acura');
INSERT INTO make (make) VALUES ('Honda');
INSERT INTO make (make) VALUES ('Hyundai');
INSERT INTO make (make) VALUES ('Lexus');
INSERT INTO make (make) VALUES ('Mazda');
INSERT INTO make (make) VALUES ('Nissan');
INSERT INTO make (make) VALUES ('Subaru');
----------------------------------------------
INSERT INTO model (model) VALUES ('Rogue');
INSERT INTO model (model) VALUES ('Titan');
INSERT INTO model (model) VALUES ('Altima');
INSERT INTO model (model) VALUES ('Frontier');
INSERT INTO model (model) VALUES ('Atenza');
INSERT INTO model (model) VALUES ('CX-3');
INSERT INTO model (model) VALUES ('Axela');
INSERT INTO model (model) VALUES ('Demio');
INSERT INTO model (model) VALUES ('Renegade');
INSERT INTO model (model) VALUES ('Compass');
INSERT INTO model (model) VALUES ('Wrangler');
----------------------------------------------
INSERT INTO transmission (transmission) VALUES ('9 Speed Automatic');
----------------------------------------------
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES 
('9', '18', '16', '2', '6', '3', '5', 'JF1SG63685H737629', 5, 27360.00, 2023);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('7', '18', '17', '4', '4', '4', '8', '2HGEJ6617YH561116', 8, 39700.00, 2023);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('1', '18', '18', '6', '6', '3', '5', '1N6AD0EV9BC405351', 2, 26385.00, 2023);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('5', '18', '19', '8', '3', '3', '8', '2T1BU4EE4AC381738', 10, 39914.00, 2023);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('4', '17', '20', '3', '1', '5', '4', '1G8JW54RX3Y520537', 18000, 41700.00, 2021);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('1', '17', '21', '6', '5', '5', '4', '1FMJU1J5XAEA76057', 26000, 19635.00, 2019);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('8', '17', '22', '9', '7', '5', '2', '4S4BRCDC2E3267937', 53000, 12151.00, 2014);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('9', '17', '23', '12', '1', '5', '2', 'JM1BJ245221484094', 21000, 15991.00, 2019);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('9', '9', '24', '14', '7', '5', '4', '4T4BF1FK1ER374026', 10, 29745.00, 2023);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('9', '9', '25', '16', '7', '5', '2', '1FMZU63W72ZB66847', 9000, 24495.00, 2021);
INSERT INTO vehicle (type, make, model, color, engine, cylinders, transmission, vin, odometer, retail, year) VALUES
('9', '9', '26', '18', '1', '5', '1', '1GKKR3BJ228168', 12000, 46900.00, 2020);
----------------------------------------------
CREATE TABLE makeModel(
    makeId int NOT NULL,
    modelId int NOT NULL,
    primary key (makeId, modelId),
    foreign key (makeId) REFERENCES make (id),
    foreign key (modelId) REFERENCES model (id)
);
----------------------------------------------
INSERT INTO makeModel (makeId, modelId)
SELECT DISTINCT make, model
FROM vehicle;