SQL> select count(*) total,
  2         count(decode(extract(year from hiredate), 1981, empno)) "1981",
  3         count(decode(extract(year from hiredate), 1982, empno)) "1982",
  4         count(decode(extract(year from hiredate), 1983, empno)) "1983",
  5         count(decode(extract(year from hiredate), 1984, empno)) "1984",
  6         count(decode(extract(year from hiredate), 1986, empno)) "1986"
  7  from emp;
     TOTAL       1981       1982       1983       1984       1986
---------- ---------- ---------- ---------- ---------- ----------
        14         10          1          0          0          0