Who are all the ministers?
select minister from party
When did they each start?
select minister, took_office from party
When did they each leave?
select minister, left_office from party
Who left most recently?
select minister from party order by left_office desc limit 1