Database: cre_Doc_Control_Systems
Question: How many employees does each role have? List role description, id and number of employees.
SQL:
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;