CREATE TABLE stay (patient VARCHAR2, room VARCHAR2, staystart VARCHAR2)

Find the patient who most recently stayed in room 111.
SELECT patient FROM stay WHERE room = 111 ORDER BY staystart DESC LIMIT 1
SELECT "patient" FROM "stay" WHERE "room" = 111 ORDER BY "staystart" DESC FETCH FIRST 1 ROWS ONLY