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

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" NULLS FIRST