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

Show the number of venue from each venue
SELECT Venue, COUNT(Venue) FROM workshop GROUP BY Venue
SELECT "Venue", COUNT("Venue") FROM "workshop" GROUP BY "Venue"