Database: party_people
Question: Who are the ministers and what parties do they belong to, listed descending by the times they took office?
SQL:
SELECT minister ,  party_name FROM party ORDER BY took_office DESC