CREATE TABLE party_events (event_id NUMBER, event_name CLOB, party_id NUMBER, member_in_charge_id NUMBER)
CREATE TABLE member (member_id NUMBER, member_name CLOB, party_id CLOB, in_office CLOB)
CREATE TABLE party (party_id NUMBER, minister CLOB, took_office CLOB, left_office CLOB, region_id NUMBER, party_name CLOB)
CREATE TABLE region (region_id NUMBER, region_name CLOB, date CLOB, label CLOB, format CLOB, catalogue CLOB)

Who are the ministers, when did they take office, and when did they leave office, ordered by when they left office?
SELECT minister, took_office, left_office FROM party ORDER BY left_office
SELECT "minister", "took_office", "left_office" FROM "party" ORDER BY "left_office"