Translate the following question to SQL: Show the ministers and the time they took and left office, listed by the time they left office.

Schema: CREATE TABLE region (
    Region_ID INT   PRIMARY KEY,
    Region_name TEXT,
    Date TEXT,
    Label TEXT,
    Format TEXT,
    Catalogue TEXT,
    UNIQUE (Region_ID)
);

CREATE TABLE party (
    Party_ID INT   PRIMARY KEY,
    Minister TEXT,
    Took_office TEXT,
    Left_office TEXT,
    Region_ID INT,
    Party_name TEXT,
    UNIQUE (Party_ID),
    FOREIGN KEY (Region_ID) REFERENCES region(Region_ID)
);

CREATE TABLE member (
    Member_ID INT   PRIMARY KEY,
    Member_Name TEXT,
    Party_ID TEXT,
    In_office TEXT,
    UNIQUE (Member_ID),
    FOREIGN KEY (Party_ID) REFERENCES party(Party_ID)
);

CREATE TABLE party_events (
    Event_ID INT   PRIMARY KEY,
    Event_Name TEXT,
    Party_ID INT,
    Member_in_charge_ID INT,
    UNIQUE (Event_ID),
    FOREIGN KEY (Member_in_charge_ID) REFERENCES member(Member_ID),
    FOREIGN KEY (Party_ID) REFERENCES party(Party_ID)
);
user
SELECT minister ,  took_office ,  left_office FROM party ORDER BY left_office
assistant