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

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"