Visualize a pie chart with how many workshops did each author submit to? Return the author name and the number of workshops.
CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
)
SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID
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: Visualize a pie chart with how many workshops did each author submit to? Return the author name and the number of workshops. ### Input: CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
) ### Response: SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID