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)
CREATE TABLE member (member_id DECIMAL, member_name TEXT, party_id TEXT, in_office TEXT)
CREATE TABLE party_events (event_id DECIMAL, event_name TEXT, party_id DECIMAL, member_in_charge_id DECIMAL)

Show all ministers and parties they belong to in descending order of the time they took office.
SELECT minister, party_name FROM party ORDER BY took_office DESC
SELECT "minister", "party_name" FROM "party" ORDER BY "took_office" DESC NULLS LAST