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
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT minister, party_name FROM party ORDER BY took_office DESC </s>