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

What are the venues of all the matches? Sort them in the descending order of match date, and count them by a bar chart
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