CREATE TABLE party (minister VARCHAR, party_name VARCHAR, took_office VARCHAR)

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