Which patient is staying in room 111? Tell me the patient id.
select patient from stay where room = 111
What is the id of the medication used for this patient?
select t3.medication from stay as t1 join patient as t2 on t1.patient = t2.ssn join prescribes as t3 on t3.patient = t2.ssn where room = 111
What is the name of the medication?
select t4.name from stay as t1 join patient as t2 on t1.patient = t2.ssn join prescribes as t3 on t3.patient = t2.ssn join medication as t4 on t3.medication = t4.code where room = 111