SELECT patient FROM stay WHERE room  =  111 ORDER BY staystart DESC LIMIT 1
What is the id of the patient who stayed in room 111 most recently?
SELECT patient FROM stay WHERE room = 111 ORDER BY staystart DESC LIMIT 1
select patient from stay where room = value order by staystart desc limit value
What is the id of the patient who stayed in room 111 most recently ?