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

Create a bar chart showing the number of author across author, could you list in asc by the Author?
SELECT Author, COUNT(Author) FROM submission GROUP BY Author ORDER BY Author
SELECT "Author", COUNT("Author") FROM "submission" GROUP BY "Author" ORDER BY "Author"