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

Show each author and the number of workshops they submitted to Show bar chart, and show by the bar in asc.
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"