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

Show each author and the number of workshops they submitted to Show bar chart, show in asc by the total number.
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)
SELECT "Author", COUNT(DISTINCT "T1"."Workshop_ID") FROM "Acceptance" "T1" JOIN "submission" "T2" ON "T1"."Submission_ID" = "T2"."Submission_ID" ORDER BY COUNT(DISTINCT "T1"."Workshop_ID")