Show all ministers and parties they belong to in descending order of the time they took office.
CREATE TABLE party (
    minister VARCHAR,
    party_name VARCHAR,
    took_office VARCHAR
)
SELECT minister, party_name FROM party ORDER BY took_office 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: Show all ministers and parties they belong to in descending order of the time they took office. ### Input: CREATE TABLE party (
    minister VARCHAR,
    party_name VARCHAR,
    took_office VARCHAR
) ### Response: SELECT minister, party_name FROM party ORDER BY took_office DESC