What is the code of each role and the number of employees in each role?
select role_code, count(*) from employees group by role_code