SELECT d.department_id, d.department_name, nvl2(e.manager_id,to_char(e.manager_id),'No appointed manager') manager_id, SUBSTR(e.first_name,1,1)||'. '||e.last_name "Име и Фамилия"
FROM employees e RIGHT OUTER JOIN departments d ON e.employee_id=d.manager_id
WHERE d.department_id IS NOT NULL
ORDER BY department_id;