---

CREATE TABLE cars (
    id INT PRIMARY KEY AUTO_INCREMENT,
    brand VARCHAR(50) NOT NULL,
    model VARCHAR(50) NOT NULL,
    year INT NOT NULL,
    price INT NOT NULL,
    mileage INT NOT NULL,
    fuel VARCHAR(30) NOT NULL
);

INSERT INTO cars (brand, model, year, price, mileage, fuel) VALUES
('BMW', 'X5', 2020, 4500000, 65000, 'Дизель'),
('Lada', 'Vesta', 2019, 1100000, 85000, 'Бензин'),
('Mercedes-Benz', 'E-Class', 2018, 3200000, 110000, 'Бензин'),
('Audi', 'A4', 2016, 1850000, 130000, 'Бензин'),
('Toyota', 'Camry', 2008, 950000, 210000, 'Бензин'),
('BMW', '3 Series', 2007, 750000, 240000, 'Бензин'),
('Kia', 'Rio', 2021, 1400000, 40000, 'Бензин'),
('Tesla', 'Model 3', 2022, 3800000, 25000, 'Электро'),
('Lada', 'Granta', 2014, 450000, 145000, 'Бензин'),
('Volkswagen', 'Touareg', 2017, 2900000, 95000, 'Дизель');