zad1
select distinct first_name, last_name, regional_group from employee, department, location
where employee.department_id = department.department_id
AND department.location_id = location.location_id order by last_name, regional_group;

zad2
select last_name, first_name from employee a, employee b where a.employee_id = b.manager_id;