(select e.department_id, avg(salary)
from employees e
group by e.department_id
having avg(salary) > 0
order by avg(salary) desc
limit 1)
union
(select e.department_id, avg(salary)
from employees e
group by e.department_id
having avg(salary) > 0
order by avg(salary) asc
limit 1)
union在最后执行,在order之后