CREATE TABLE INVENTORY 
(
  	 CarId VARCHAR PRIMARY KEY,
 	 CarName VARCHAR NOT NULL,
     Price INTEGER NOT NULL,
  	 Model VARCHAR,
  	 YearManufacturer INTEGER,
  	 FuelType VARCHAR
);

-- insert RECORDS
INSERT INTO INVENTORY VALUES ('D001', 'Car1', 582613.00, 'LXI', 2017, 'Petrol');
INSERT INTO INVENTORY VALUES ('D002', 'Car1', 673112.00, 'VXI', 2018, 'Petrol');
INSERT INTO INVENTORY VALUES ('B001', 'Car2', 567031.00, 'Sigma1.2', 2019, 'Petrol');
INSERT INTO INVENTORY VALUES ('B002', 'Car2', 647858.00,  'Delta1.2',  2018, 'Petrol');

-- show the records of cars manufactured in 2018 (selective rows)
SELECT * FROM INVENTORY 
WHERE YearManufacturer=2018;