How many employees does each role have? Plot a pie chart.
CREATE TABLE Ref_Document_Types (
    document_type_code CHAR(15),
    document_type_description VARCHAR(255)
)

CREATE TABLE Addresses (
    address_id INTEGER,
    address_details VARCHAR(255)
)

CREATE TABLE Document_Drafts (
    document_id INTEGER,
    draft_number INTEGER,
    draft_details VARCHAR(255)
)

CREATE TABLE Circulation_History (
    document_id INTEGER,
    draft_number INTEGER,
    copy_number INTEGER,
    employee_id INTEGER
)

CREATE TABLE Roles (
    role_code CHAR(15),
    role_description VARCHAR(255)
)

CREATE TABLE Documents (
    document_id INTEGER,
    document_status_code CHAR(15),
    document_type_code CHAR(15),
    shipping_agent_code CHAR(15),
    receipt_date DATETIME,
    receipt_number VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Documents_Mailed (
    document_id INTEGER,
    mailed_to_address_id INTEGER,
    mailing_date DATETIME
)

CREATE TABLE Ref_Document_Status (
    document_status_code CHAR(15),
    document_status_description VARCHAR(255)
)

CREATE TABLE Draft_Copies (
    document_id INTEGER,
    draft_number INTEGER,
    copy_number INTEGER
)

CREATE TABLE Employees (
    employee_id INTEGER,
    role_code CHAR(15),
    employee_name VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Ref_Shipping_Agents (
    shipping_agent_code CHAR(15),
    shipping_agent_name VARCHAR(255),
    shipping_agent_description VARCHAR(255)
)
SELECT role_description, 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? Plot a pie chart. ### Input: CREATE TABLE Ref_Document_Types (
    document_type_code CHAR(15),
    document_type_description VARCHAR(255)
)

CREATE TABLE Addresses (
    address_id INTEGER,
    address_details VARCHAR(255)
)

CREATE TABLE Document_Drafts (
    document_id INTEGER,
    draft_number INTEGER,
    draft_details VARCHAR(255)
)

CREATE TABLE Circulation_History (
    document_id INTEGER,
    draft_number INTEGER,
    copy_number INTEGER,
    employee_id INTEGER
)

CREATE TABLE Roles (
    role_code CHAR(15),
    role_description VARCHAR(255)
)

CREATE TABLE Documents (
    document_id INTEGER,
    document_status_code CHAR(15),
    document_type_code CHAR(15),
    shipping_agent_code CHAR(15),
    receipt_date DATETIME,
    receipt_number VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Documents_Mailed (
    document_id INTEGER,
    mailed_to_address_id INTEGER,
    mailing_date DATETIME
)

CREATE TABLE Ref_Document_Status (
    document_status_code CHAR(15),
    document_status_description VARCHAR(255)
)

CREATE TABLE Draft_Copies (
    document_id INTEGER,
    draft_number INTEGER,
    copy_number INTEGER
)

CREATE TABLE Employees (
    employee_id INTEGER,
    role_code CHAR(15),
    employee_name VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Ref_Shipping_Agents (
    shipping_agent_code CHAR(15),
    shipping_agent_name VARCHAR(255),
    shipping_agent_description VARCHAR(255)
) ### Response: SELECT role_description, COUNT(*) FROM Roles AS T1 JOIN Employees AS T2 ON T1.role_code = T2.role_code GROUP BY T2.role_code