CREATE TABLE Employees (Id VARCHAR2)
CREATE TABLE ROLES (Id VARCHAR2)

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") > 1