SELECT minister, party_name FROM party ORDER BY took_office DESC
Who are the ministers and what parties do they belong to, listed descending by the times they took office?
CREATE TABLE region (
    region_id number,
    region_name text,
    date text,
    label text,
    format text,
    catalogue text
)

CREATE TABLE party (
    party_id number,
    minister text,
    took_office text,
    left_office text,
    region_id number,
    party_name text
)

CREATE TABLE member (
    member_id number,
    member_name text,
    party_id text,
    in_office text
)

CREATE TABLE party_events (
    event_id number,
    event_name text,
    party_id number,
    member_in_charge_id number
)