SELECT role_code ,  count(*) FROM Employees GROUP BY role_code
Show all role codes 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
Show all role codes and the number of employees in each role .