CREATE TABLE Employees (role_code VARCHAR(255))
Show all role codes and the number of employees in each role.
    
SQL: SELECT role_code, COUNT(*) FROM Employees GROUP BY role_code