CREATE TABLE INVENTORY 
(
  	 CarId VARCHAR PRIMARY KEY,
 	 CarName VARCHAR NOT NULL,
     Price DECIMAL(10,2) 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.80, 'VXI', 2018, 'Petrol');
INSERT INTO INVENTORY VALUES ('B001', 'Car2', 567031.99, 'Sigma1.2', 2019, 'Petrol');
INSERT INTO INVENTORY VALUES ('B002', 'Car2', 647858.60,  'Delta1.2',  2018, 'Petrol');

-- show the GST amount @12% for each car – (selective columns)

SELECT Price + Price*12/100 AS “Final_Amount” FROM INVENTORY;

ALTER   TABLE     INVENTORY    ADD(FinalPrice DECIMAL(10,3));