Create a bar chart showing the number of author across author
CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
)

CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
)
SELECT Author, COUNT(Author) FROM submission GROUP BY Author
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: Create a bar chart showing the number of author across author ### Input: CREATE TABLE Acceptance (
    Submission_ID int,
    Workshop_ID int,
    Result text
)

CREATE TABLE submission (
    Submission_ID int,
    Scores real,
    Author text,
    College text
)

CREATE TABLE workshop (
    Workshop_ID int,
    Date text,
    Venue text,
    Name text
) ### Response: SELECT Author, COUNT(Author) FROM submission GROUP BY Author