select e.deptno,
       count(case
                when e.sal <= 2000 then e.sal
                else null
              end) "<=2000",
       count(case
                when e.sal > 2000 then e.sal
                else null
              end) ">2000"
from emp e
group by e.deptno;