CREATE TABLE match (Match_ID INT, Date TEXT, Venue TEXT, Score TEXT, Result TEXT, Competition TEXT)
CREATE TABLE hosting_city (Year INT, Match_ID INT, Host_City TEXT)
CREATE TABLE city (City_ID INT, City TEXT, Hanzi TEXT, Hanyu_Pinyin TEXT, Regional_Population INT, GDP FLOAT)
CREATE TABLE temperature (City_ID INT, Jan FLOAT, Feb FLOAT, Mar FLOAT, Apr FLOAT, Jun FLOAT, Jul FLOAT, Aug FLOAT, Sep FLOAT, Oct FLOAT, Nov FLOAT, Dec FLOAT)

What are the number of the venues of all the matches? Sort them in the descending order of match date.
SELECT Venue, COUNT(Venue) FROM match GROUP BY Venue ORDER BY Date DESC
SELECT "Venue", COUNT("Venue") FROM "match" GROUP BY "Venue" ORDER BY "Date" DESC NULLS LAST