CREATE TABLE match (Match_ID NUMBER, Date CLOB, Venue CLOB, Score CLOB, Result CLOB, Competition 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 hosting_city (Year NUMBER, Match_ID NUMBER, Host_City CLOB)
CREATE TABLE city (City_ID NUMBER, City CLOB, Hanzi CLOB, Hanyu_Pinyin CLOB, Regional_Population NUMBER, GDP FLOAT)

List venues of all matches in the order of their dates starting from the most recent one, 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