select years2, count(years), count(years2), count(years)-count(years2) from ( -- select extract(year from ((sysdate - hire_date) year to month)) years from employees select extract(year from ((sysdate - hire_date) year to month)) years, trunc((sysdate - hire_date)/365) years2 from employees ) group by years2 order by years2