CREATE TABLE city (city_id NUMBER, city CLOB, hanzi CLOB, hanyu_pinyin CLOB, regional_population NUMBER, gdp NUMBER)
CREATE TABLE match (match_id NUMBER, date CLOB, venue CLOB, score CLOB, result CLOB, competition CLOB)
CREATE TABLE temperature (city_id NUMBER, jan NUMBER, feb NUMBER, mar NUMBER, apr NUMBER, jun NUMBER, jul NUMBER, aug NUMBER, sep NUMBER, oct NUMBER, nov NUMBER, dec NUMBER)
CREATE TABLE hosting_city (year NUMBER, match_id NUMBER, host_city CLOB)

List venues of all matches in the order of their dates starting from the most recent one.
SELECT venue FROM match ORDER BY date DESC
SELECT "venue" FROM "match" ORDER BY "date" DESC