JOIN NOW

Computer Science

In the added column Grade, assign grades as follows :

if sal is in range 700 — 1500, Grade is 1 ;
if sal is in range 1500 — 2200, Grade is 2 ;
if sal is in range 2200 — 3000, Grade is 3 ;
if sal is in range 3000 — Grade is 4 ;

DDL & DML

4 Likes

Answer

UPDATE Empl
SET Grade = '1'
WHERE Sal >= 700 AND Sal <= 1500;

UPDATE Empl
SET Grade = '2'
WHERE Sal > 1500 AND Sal <= 2200;

UPDATE Empl
SET Grade = '3'
WHERE Sal > 2200 AND Sal <= 3000;

UPDATE Empl
SET Grade = '4'
WHERE Sal > 3000;

Answered By

2 Likes

Related Questions