Database: party_people
Question: Who are the ministers, when did they take office, and when did they leave office, ordered by when they left office?
SQL:
SELECT minister ,  took_office ,  left_office FROM party ORDER BY left_office