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
What is the name of the medication used for the patient staying in room 111?
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
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 = value
What is the name of the medication used for the patient staying in room 111 ?