-- Create the cars table
CREATE TABLE cars (
    id INT AUTO_INCREMENT PRIMARY KEY,
    cartype VARCHAR(255),
    license_plate VARCHAR(255),
    year INT,
    manufacturer VARCHAR(255),
    km INT
);

-- Insert data into the cars table
INSERT INTO cars (cartype, license_plate, year, manufacturer, km) VALUES
('SUV', 'ABC123', 2015, 'Toyota', 75000),
('Sedan', 'XYZ456', 2012, 'Honda', 40000),
('Truck', 'DEF789', 2018, 'Ford', 110000),
('Hatchback', 'GHI123', 2016, 'Chevrolet', 30000),
('Convertible', 'JKL456', 2019, 'Volkswagen', 2000),
('Coupe', 'MNO789', 2014, 'BMW', 80000),
('SUV', 'PQR123', 2017, 'Mercedes-Benz', 95000),
('Truck', 'STU456', 2013, 'Audi', 70000),
('Hatchback', 'VWX789', 2010, 'Lexus', 100000),
('Sedan', 'YZA123', 2011, 'Nissan', 60000),
('Convertible', 'BCD789', 2013, 'Toyota', 58000),
('Coupe', 'EFG123', 2016, 'BMW', 72000),
('Truck', 'HIJ789', 2019, 'Ford', 25000),
('SUV', 'KLM123', 2015, 'Honda', 87000),
('Hatchback', 'NOP789', 2018, 'Chevrolet', 32000),
('Convertible', 'QRS123', 2014, 'Volkswagen', 41000),
('Coupe', 'TUV789', 2017, 'BMW', 67000),
('SUV', 'VWX123', 2018, 'Mercedes-Benz', 93000),
('Truck', 'YZA789', 2016, 'Audi', 78000),
('Hatchback', 'BCD123', 2012, 'Lexus', 105000),
('Sedan', 'EFG789', 2014, 'Nissan', 69000),
('SUV', 'FGH123', 2019, 'Toyota', 54000),
('Convertible', 'IJK789', 2016, 'Volkswagen', 62000),
('Coupe', 'LMN123', 2011, 'BMW', 88000),
('Truck', 'OPQ789', 2017, 'Ford', 47000),
('SUV', 'RST123', 2013, 'Honda', 72000),
('Hatchback', 'UVW789', 2018, 'Chevrolet', 38000),
('Convertible', 'XYZ123', 2015, 'Volkswagen', 68000),
('Coupe', '456789', 2012, 'BMW', 110000),
('Truck', '987654', 2019, 'Ford', 29000),
('SUV', '321098', 2014, 'Toyota', 63000),
('Sedan', '13579', 2016, 'Nissan', 54000),
('Convertible', '753951', 2011, 'Volkswagen', 89000),
('Coupe', '246810', 2018, 'BMW', 45000),
('Truck', '579135', 2015, 'Ford', 76000),
('SUV', '480392', 2013, 'Toyota', 84000),
('Hatchback', '135792', 2017, 'Chevrolet', 50000),
('Convertible', '579321', 2019, 'Volkswagen', 36000),
('Coupe', '802467', 2016, 'BMW', 69000);