Find the patient who most recently stayed in room 111.
create table stay (patient varchar, room varchar, staystart varchar, PRIMARY KEY (patient))
select patient from stay where room = 111 order by staystart desc limit 1