Table schema:
CREATE TABLE party (minister VARCHAR, party_name VARCHAR, took_office VARCHAR)

Question: Show all ministers and parties they belong to in descending order of the time they took office.
SQL: SELECT minister, party_name FROM party ORDER BY took_office DESC