CREATE TABLE Performa
(
  SCode INTEGER,
  SchoolName VARCHAR,
  AnnualFee DECIMAL(12,2)
);
 
INSERT INTO Performa (SCode, SchoolName, AnnualFee ) 
VALUES  
("SCode ","SchoolName              ","AnnualFee   "),
(210101,  "Bal Bharti Vidya School ",	120045),
(310901,  "Vidya Peeth Vidyala     ",	135055),
(220001,  "Netrahaat               ",	90600),
(909091,  "Gurukul                 ",	70000);

SELECT * FROM Performa;

SELECT ROUND(MOD(AnnualFee,2),1) AS Remaining_Fee FROM Performa WHERE ANNUALFEE<100000;

-- 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;