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

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