Find the patients who stayed in room 111.
select patient from stay where room = 111
Sort the patients by the stay start date, from recent to past.
select patient from stay where room = 111 order by staystart desc
Which patient stayed there most recently?
select patient from stay where room = 111 order by staystart desc limit 1