How many workshops did each author submit to? Return the author name and the number of workshops in a bar chart, and order from high to low by the Y-axis.
CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
)

CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
)
SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID ORDER BY COUNT(DISTINCT T1.Workshop_ID) DESC
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 workshops did each author submit to? Return the author name and the number of workshops in a bar chart, and order from high to low by the Y-axis. ### Input: CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
)

CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
) ### Response: SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID ORDER BY COUNT(DISTINCT T1.Workshop_ID) DESC