select E.First_Name ||' '|| E.Last_Name

AS "Employee Full Name" from Employee E

CASE

WHEN E.Salary 5000 = THEN E.Salary + ( 0.10 * E.Salary)

WHEN E.Salary 5500 = THEN E.Salary + ( 0.08 * E.Salary)

WHEN E.Salary 6000 = THEN E.Salary + ( 0.06 * E.Salary)

WHEN E.Salary 6500 = THEN E.Salary + ( 0.04 * E.Salary)

ELSE E.Salary

END AS "SALARY AFTER RAISE";