Database: cre_Doc_Control_Systems
Question: List roles that have more than one employee. List the role description and number of employees.
SQL:
SELECT Roles.role_description , count(Employees.employee_id) FROM ROLES JOIN Employees ON Employees.role_code = Roles.role_code GROUP BY Employees.role_code HAVING count(Employees.employee_id)  >  1;