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 I want to order x-axis in descending 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 DESC
SELECT "Author", COUNT(DISTINCT "T1"."Workshop_ID") FROM "Acceptance" "T1" JOIN "submission" "T2" ON "T1"."Submission_ID" = "T2"."Submission_ID" ORDER BY "Author" DESC