CREATE TABLE ROLES (role_description VARCHAR2, role_code VARCHAR2)
CREATE TABLE Employees (role_code VARCHAR2)

How many employees does each role have? List role description, id and number of employees.
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
SELECT "T1"."role_description", "T2"."role_code", COUNT(*) FROM "ROLES" "T1" JOIN "Employees" "T2" ON "T1"."role_code" = "T2"."role_code" GROUP BY "T2"."role_code"