I’ve figured out one query that returns my desired result and is also more flexible than the previously ones posted since it can return multiple rows if it was the case:
select e.job, avg(e.salary) as AVERAGE
from EMPLOYEE e
group by e.job
having avg(e.salary) >= ALL(select avg(salary) from EMPLOYEE group by job)
CLICK HERE to find out more related problems solutions.