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)

Show the number of venue from each venue, sort how many venue in desc order.
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