CREATE DATABASE vehicle ;

USE vehicle ;

CREATE TABLE vehicle_data (

Vehicle_Type VARCHAR (300),
Make VARCHAR(300),
Model VARCHAR(300),
Year_Range VARCHAR(50),
Price_Range VARCHAR(50),
Mileage_Range VARCHAR(50),
Color VARCHAR(300),
Location VARCHAR(300),
Status VARCHAR(50),
Country VARCHAR(100),
Continent VARCHAR(100)
);

INSERT INTO vehicle_data

( Vehicle_Type , Make , Model , Year_Range , Price_Range , Mileage_Range , Color ,
Location , Status , Country , Continent )
VALUES
('passenger vehicle', 'Toyota', 'Camry', '2015 To 2022', '35,00,000 - 45,00,000',
'12 - 18', 'White, Black, Silver', 'Mumbai', 'Available', 'Japan', 'Asia'),
('passenger vehicle', 'Tesla', 'Model S', '2020 To 2023', '75,00,000 - 90,00,000',
'400 - 600', 'Red, Blue, White', 'Los Angeles', 'Available', 'USA', 'North
America'),
('passenger vehicle', 'Volkswagen', 'Golf', '2015 TO 2022', '25,00,000 -
35,00,000', '14 - 20', 'Blue, Red, Black', 'Berlin', 'Available', 'Germany',
'Europe'),
('Motarcycle Vehicle', 'Kawasaki', 'Ninja ZX-10R', '2018 To 2023', '15,00,000 -
20,00,000', '12 - 15', 'Green, Black, White', 'Tokyo', 'Available', 'Japan',
'Asia'),
('Motarcycle Vehicle', 'BMW', 'S1000RR', '2019 To 2023', '18,00,000 - 24,00,000',
'10 - 13', 'Red, Black, White', 'Munich', 'Available', 'Germany', 'Europe'),
('Motarcycle Vehicle', 'Harley Davidson', 'Street 750', '2017 To 2023', '7,00,000 -
10,00,000', '17 - 20', 'Black, Red', 'New York', 'Available', 'USA', 'North
America'),
('Motarcycle Vehicle', 'Royal Enfield', 'Classic 500', '2016 To 2023', '2,50,000 -
3,50,000', '25 - 30', 'Black, Green, Silver', 'Chennai', 'Available', 'India',
'Asia'),
('Motarcycle Vehicle', 'Honda', 'Africa Twin', '2019 To 2023', '13,00,000 -
16,00,000', '16 - 19', 'Blue, Red, Black', 'Tokyo', 'Available', 'Japan', 'Asia'),
('Motarcycle Vehicle', 'BMW', 'R1250GS', '2020 To 2023', '20,00,000 - 23,00,000',
'18 - 22', 'Black, White', 'Berlin', 'Available', 'Germany', 'Europe'),
('Rrecreational vehicles', 'Winnebago', 'Travato', '2017 To 2023', '1,20,00,000 -
1,50,00,000', '8 - 10', 'White, Silver, Black', 'California', 'Available', 'USA',
'North America'),
('Rrecreational vehicles', 'Thor', 'Challenger', '2018 To 2023', '1,50,00,000 -
2,00,00,000', '7 - 9', 'Red, Black, Gray', 'Florida', 'Available', 'USA', 'North
America'),
('Rrecreational vehicles', 'Airstream', 'Classic', '2016 To 2023', '1,00,00,000 -
1,40,00,000', 'N/A', 'Silver', 'Texas', 'Available', 'USA', 'North America'),
('Rrecreational vehicles', 'Jayco', 'Jay Flight', '2015 To 2023', '50,00,000 -
70,00,000', 'N/A', 'White, Gray', 'New York', 'Available', 'USA', 'North America'),
('Rrecreational vehicles', 'Mercedes-Benz', 'Sprinter', '2018 To 2023',
'1,00,00,000 - 1,30,00,000', '10 - 12', 'White, Black, Blue', 'Berlin',
'Available', 'Germany', 'Europe'),
('Rrecreational vehicles', 'Ford', 'Transit Custom Nugget', '2019 To 2023',
'80,00,000 - 1,10,00,000', '12 - 15', 'White, Silver', 'London', 'Available', 'UK',
'Europe'),
('Special purpose vehicle', 'Pierce', 'Arrow XT', '2015 To 2023', '2,50,00,000 -
3,50,00,000', '3 - 5', 'Red, Yellow', 'New York', 'Available', 'USA', 'North
America'),
('Special purpose vehicle', 'Rosenbauer', 'Panther', '2017 To 2023', '3,00,00,000 -
4,00,00,000', '2 - 4', 'Red, Black', 'Berlin', 'Available', 'Germany', 'Europe'),
('Special purpose vehicle', 'Ford', 'Transit Ambulance', '2018 To 2023', '60,00,000
- 1,00,00,000', '10 - 12', 'White, Red', 'London', 'Available', 'UK', 'Europe'),
('Special purpose vehicle', 'Mercedes-Benz', 'Sprinter Ambulance', '2016 To 2023',
'80,00,000 - 1,20,00,000', '10 - 14', 'White, Yellow', 'Munich', 'Available',
'Germany', 'Europe'),
('Special purpose vehicle', 'Caterpillar', '745', '2015 To 2023', '1,80,00,000 -
2,50,00,000', '3 - 6', 'Yellow', 'Texas', 'Available', 'USA', 'North America'),
('Special purpose vehicle', 'Volvo', 'A45G', '2016 To 2023', '2,50,00,000 -
3,00,00,000', '4 - 7', 'Yellow, Black', 'Chicago', 'Available', 'USA', 'North
America'),
('passenger vehicle', 'Honda', 'Accord', '2015 To 2022', '30,00,000 - 40,00,000',
'12 - 16', 'Silver, Black', 'Tokyo', 'Available', 'Japan', 'Asia'),
('passenger vehicle', 'Ford', 'Fusion', '2016 To 2021', '25,00,000 - 30,00,000',
'10 - 14', 'Blue, Black', 'London', 'Available', 'UK', 'Europe'),
('passenger vehicle', 'Hyundai', 'Elantra', '2015 To 2022', '18,00,000 -
25,00,000', '14 - 18', 'White, Gray', 'Seoul', 'Available', 'South Korea', 'Asia'),
('passenger vehicle', 'Kia', 'Optima', '2015 To 2022', '20,00,000 - 30,00,000', '15
- 19', 'Silver, Black', 'Seoul', 'Available', 'South Korea', 'Asia'),
('passenger vehicle', 'Chevrolet', 'Malibu', '2016 To 2022', '22,00,000 -
28,00,000', '12 - 15', 'White, Blue', 'Los Angeles', 'Available', 'USA', 'North
America'),
('passenger vehicle', 'Nissan', 'Altima', '2015 To 2022', '25,00,000 - 30,00,000',
'14 - 17', 'Gray, White', 'Tokyo', 'Available', 'Japan', 'Asia');

SELECT * FROM vehicle_data ;