Vehicle DB

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 ;

Vehicle DB

Uploaded by

Copyright:

Available Formats

Vehicle DB

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Vehicle DB

Uploaded by

Copyright:

Available Formats

CREATE DATABASE vehicle ;

CREATE TABLE vehicle_data (

INSERT INTO vehicle_data

SELECT * FROM vehicle_data ;

You might also like