Show the ministers and the time they took and left office, listed by the time they left office.
CREATE TABLE party (minister VARCHAR, took_office VARCHAR, left_office VARCHAR)
SELECT minister, took_office, left_office FROM party ORDER BY left_office
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE party (minister VARCHAR, took_office VARCHAR, left_office VARCHAR) Question: Show the ministers and the time they took and left office, listed by the time they left office. [/INST] SELECT minister, took_office, left_office FROM party ORDER BY left_office </s>