Find the patient who most recently stayed in room 111.
SELECT patient FROM stay WHERE room  =  111 ORDER BY staystart DESC LIMIT 1
most recently stayed refers to MAX(staystart); in room 111 refers to room = 111;