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

Visualize a pie chart for how many authors submit to the workshop.
SELECT Author, COUNT(Author) FROM submission GROUP BY Author
SELECT "Author", COUNT("Author") FROM "submission" GROUP BY "Author"