How many employees does each role have? List role description, id and number of employees.
CREATE TABLE ROLES (
    role_description VARCHAR,
    role_code VARCHAR
)

CREATE TABLE Employees (
    role_code VARCHAR
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many employees does each role have? List role description, id and number of employees. ### Input: CREATE TABLE ROLES (
    role_description VARCHAR,
    role_code VARCHAR
)

CREATE TABLE Employees (
    role_code VARCHAR
) ### Response: 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