CREATE TABLE Performa
(
  	 RollCode INTEGER,
  	 Stud_Name VARCHAR,
  	 UT1 DECIMAL(6,2),
  	 UT2 DECIMAL(6,2),
     PB1 DECIMAL(6,2),
     PB2 DECIMAL(6,2)
);

INSERT INTO Performa (RollCode, Stud_Name, UT1, UT2, PB1, PB2) 
VALUES ("RollCode ","Stud_Name   ","UT1 ","UT2 ","PB1 ","PB2 "),
(2065444101, "Ananya     ", 24.5, 26.5, 60.5, 66.5),
(2065444102, "Bhavya     ", 20.5, 23.5, 58.5, 62.0),
(2065444103, "Cindrella  ", 23.5, 20.5, 58.5, 64.0),
(2065444104, "Devansh    ", 24.5, 26.5, 60.5, 66.5),
(2065444105, "Emlin      ", 22.5, 28.5, 70.5, 68.5);

-- ALTER TABLE SALES ADD Commission DECIMAL(10,3);

-- UPDATE SALES SET Commission = SalePrice*12/100;

 SELECT ROUND((PB1+PB2)/2,1) FROM Performa WHERE UT1 <21;
 
 

-- SELECT ROUND(SalePrice,2) FROM SALES WHERE PaymentMode = "Online      ";

-- SELECT CarId,  ROUND(Commission/SalePrice*100) FROM Sales;

-- SELECT CustId, SalePrice*6/100 AS Discount FROM Sales;

-- SELECT CustId, ROUND(SalePrice*6/100,2) AS Discount FROM Sales;