Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it.

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 ;

Insert a record of your choice in table Empl. Make sure not to enter Grade.

Modify the definition of column Grade. Increase its size to 2.