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)
CREATE TABLE city (City_ID INT, City TEXT, Hanzi TEXT, Hanyu_Pinyin TEXT, Regional_Population INT, GDP FLOAT)
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)

List venues of all matches in the order of their dates starting from the most recent one, and count them by a pie 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 NULLS LAST