List venues of all matches in the order of their dates starting from the most recent one, and count them by a pie chart
CREATE TABLE temperature (
    City_ID int,
    Jan real,
    Feb real,
    Mar real,
    Apr real,
    Jun real,
    Jul real,
    Aug real,
    Sep real,
    Oct real,
    Nov real,
    Dec real
)

CREATE TABLE city (
    City_ID int,
    City text,
    Hanzi text,
    Hanyu_Pinyin text,
    Regional_Population int,
    GDP real
)

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
)
SELECT Venue, COUNT(Venue) FROM match GROUP BY Venue ORDER BY Date DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: List venues of all matches in the order of their dates starting from the most recent one, and count them by a pie chart ### Input: CREATE TABLE temperature (
    City_ID int,
    Jan real,
    Feb real,
    Mar real,
    Apr real,
    Jun real,
    Jul real,
    Aug real,
    Sep real,
    Oct real,
    Nov real,
    Dec real
)

CREATE TABLE city (
    City_ID int,
    City text,
    Hanzi text,
    Hanyu_Pinyin text,
    Regional_Population int,
    GDP real
)

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
) ### Response: SELECT Venue, COUNT(Venue) FROM match GROUP BY Venue ORDER BY Date DESC