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

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 NULLS LAST