CREATE TABLE Employees (role_code VARCHAR2)

Show all role codes and the number of employees in each role.
SELECT role_code, COUNT(*) FROM Employees GROUP BY role_code
SELECT "role_code", COUNT(*) FROM "Employees" GROUP BY "role_code"