Show the role code for all employees.
select role_code from employees
For each of them, also show the number of employees in each role.
select role_code, count(*) from employees group by role_code