CREATE TABLE stay (patient VARCHAR, room VARCHAR, staystart VARCHAR)
SELECT patient FROM stay WHERE room = 111 ORDER BY staystart DESC LIMIT 1
ค้นหาผู้ป่วยที่เพิ่งพักในห้อง 111
Find the patient who most recently stayed in room 111.