What are the employees' id?
select employee_id from employees;
Which of those ids correspond to roles with more than 2 employees? Show in conjunction to the ids.
select roles.role_description, employees.employee_id from roles join employees on employees.role_code = roles.role_code group by employees.role_code having count(employees.employee_id) > 2;
How about more than 1 employee? Now only show the role description and number of employee ids.
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;