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

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" NULLS FIRST