1.
select last_name, first_name, initcap(regional_group) city
from employee e , location l , department d
where e.department_id = d.department_id
and l.location_id = d.location_id;


2.
select last_name, first_name
from employee e , job j
where e.job_id = j.job_id
and j.function = 'MANAGER'
order by 1,2

3.
select distinct last_name, first_name
from employee e , location l , department d, customer c
where e.department_id = d.department_id
and l.location_id = d.location_id
and e.employee_id = c.salesperson_id
and regional_group = city

4.
SELECT sz.last_name, sz.first_name, pr.last_name, pr.first_name
FROM EMPLOYEE sz, EMPLOYEE pr
WHERE sz.employee_id = pr.manager_id
AND sz.salary < pr.salary;

5.
select last_name, first_name , name, pro.description, i.actual_price
from employee e , customer c, item i, sales_order so, product pro
where e.employee_id = c.salesperson_id
and c.customer_id = so.customer_id
and so.order_id = i.order_id
and i.product_id = pro.product_id;