dbms practical no 98

CREATE TABLE employees (
name TEXT NOT NULL,
ssn integer NOT NULL,
gross integer not null,
income_tax integer not null
);

INSERT INTO employees VALUES ('Rajat',519,58000,0);
INSERT INTO employees VALUES ('Deepak',532,72000,0);
INSERT INTO employees VALUES ('Abhishek',530,38000,0);
INSERT INTO employees VALUES ('Navi',505,112000,0);
INSERT INTO employees VALUES ('Shubham',525,90000,0);

SELECT gross,income_tax,
CASE
WHEN gross<=40000
THEN 0
WHEN gross>40000 AND gross<60000
THEN (gross-40000)*0.10
WHEN gross>60000 AND gross<100000
THEN (gross-60000)*0.20
ELSE (gross-100000)*0.30
END
FROM employees;