Database: party_people
Question: Show all ministers and parties they belong to in descending order of the time they took office.
SQL:
SELECT minister ,  party_name FROM party ORDER BY took_office DESC