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

Draw a bar chart that counts the number of venues of each workshop, and rank by the Y-axis in descending.
SELECT Venue, COUNT(Venue) FROM workshop GROUP BY Venue ORDER BY COUNT(Venue) DESC
SELECT "Venue", COUNT("Venue") FROM "workshop" GROUP BY "Venue" ORDER BY COUNT("Venue") DESC