Task: Text to Code
Input (English): What is the id of the patient who stayed in room 111 most recently?
Output (English): SELECT patient FROM stay WHERE room  =  111 ORDER BY staystart DESC LIMIT 1