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;