SELECT T1.role_description ,  T2.role_code ,  count(*) FROM ROLES AS T1 JOIN Employees AS T2 ON T1.role_code = T2.role_code GROUP BY T2.role_code;
How many employees does each role have? List role description, id and number of employees.
SELECT T1.role_description , T2.role_code , count ( * ) FROM ROLES AS T1 JOIN Employees AS T2 ON T1.role_code = T2.role_code GROUP BY T2.role_code ;
select t1 . role_description , t2 . role_code , count ( * ) from roles as t1 join employees as t2 on t1 . role_code = t2 . role_code group by t2 . role_code
How many employees does each role have ? List role description , id and number of employees .