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;
List roles that have more than one employee. List the role description and number of employees.
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 ;
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 ) > value
List roles that have more than one employee . List the role description and number of employees .