CREATE TABLE submission (Submission_ID NUMBER, Scores FLOAT, Author CLOB, College CLOB)
CREATE TABLE workshop (Workshop_ID NUMBER, Date CLOB, Venue CLOB, Name CLOB)
CREATE TABLE Acceptance (Submission_ID NUMBER, Workshop_ID NUMBER, Result CLOB)

Visualize a bar chart for how many workshops did each author submit to? Return the author name and the number of workshops, display names from low to high order.
SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID ORDER BY Author
SELECT "Author", COUNT(DISTINCT "T1"."Workshop_ID") FROM "Acceptance" "T1" JOIN "submission" "T2" ON "T1"."Submission_ID" = "T2"."Submission_ID" ORDER BY "Author"