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.60, 'LXI', 2017, 'Petrol');
INSERT INTO INVENTORY VALUES ('D002', 'Car1', 673112.50, 'VXI', 2018, 'Petrol');
INSERT INTO INVENTORY VALUES ('B001', 'Car2', 567031.99, 'Sigma1.2', 2019, 'Petrol');
INSERT INTO INVENTORY VALUES ('B002', 'Car2', 647858.80,  'Delta1.2',  2018, 'Petrol');


SELECT Price*12/100 AS "GST" FROM INVENTORY; 

SELECT ROUND(Price*12/100,2) AS "GST" FROM INVENTORY; 

SELECT ROUND(Price + Price*12/100,2) AS "GST" FROM INVENTORY;