SELECT role_code ,  count(*) FROM Employees GROUP BY role_code
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
select role_code , count ( * ) from employees group by role_code
What is the code of each role and the number of employees in each role ?