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