SQL Practice Questions - Day13

@LearnWithRD0529 Create table and insert scripts - -------------------------------------------------- CREATE TABLE vehicle ( vehicle_id INT PRIMARY KEY, make VARCHAR(50), model VARCHAR(50), year INT, color VARCHAR(20), vin_number VARCHAR(17) UNIQUE ); -- Insert 11 sample vehicle records INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES (1, 'Toyota', 'Camry', 2020, 'Silver', '1HGCM82633A123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(2, 'Honda', 'Civic', 2019, 'Blue', '2HGFC2F53KH123457'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(3, 'Ford', 'F-150', 2021, 'Red', '1FTMF1EP0MFA12345'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(4, 'Chevrolet', 'Malibu', 2018, 'Black', '1G1ZD5ST0JF123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(5, 'Nissan', 'Altima', 2020, 'White', '1N4BL4CV0LC123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(6, 'Jeep', 'Wrangler', 2017, 'Green', '1C4HJXFG2JW123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(7, 'Toyota', 'Corolla', 2022, 'Silver', '5YFEPRAEXNP123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(8, 'Subaru', 'Outback', 2019, 'Gray', '4S4BSANC2K3A12345'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(9, 'BMW', 'X5', 2020, 'Black', '5UXCR6C00L9B12345'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(10, 'Audi', 'A4', 2021, 'Blue', 'WAUAFAFL4JA123456'); INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES(11, 'Hyundai', 'Elantra', 2018, 'Red', '5NPD84LF0JH123456');