1)
select bla.* from
(
select t1.first_name "f", t1.last_name "n", count(*) "c"
from employees t1
inner join job_history t2 on t2.employee_id = t1.employee_id
inner join departments t3 on t3.departments_id = t2.departments_id
inner join locations t4 on t4.location_id = t3.location_id
inner join countries t5 on t5.country_id = t4.country_id
inner join regions t6 on t6.region_id = t5.region_id
where t6.region_name in (‘AMERICA’, ‘EUROPE’)
group by t1.first_name, t1.last_name
) bla
where bla."c" > 2
