select job_id, department_id, 1 AS "sorteerDummy1"
from employees
where department_id = 10
union
select job_id, department_id, 2
from employees
where department_id = 50
union
select job_id, department_id, 3
from employees
where department_id = 20
ORDER  BY  3