SELECT *
FROM ( select 'raise 5%' raise,e.employee_id as employee_id,e.salary,e.salary*0.05 as newsalary
from employees e
where e.department_id in (10,50,110))
UNION ALL
SELECT *
FROM ( select 'raise 10%' raise,e.employee_id as employee_id,e.salary,e.salary*0.10 as newsalary
from employees e
where e.department_id = 60)
UNION ALL
SELECT * FROM (select 'raise 15%' raise,e.employee_id as employee_id,e.salary,e.salary*0.15 as newsalary
from employees e
where e.department_id in (80,20))
union all
SELECT * FROM (select 'no raise' raise,e.employee_id as employee_id,e.salary,e.salary*0.00 as newsalary
from employees e
where e.department_id = 90)