I want to know their room number.
select room from stay
What is the patient's name in room 111?
select t1.name from stay as t4 join patient as t1 where t4.patient = t1.ssn and t4.room = 111
What is the name and dose of the medication?
select distinct t4.name, t3.dose 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 t2.name = 'John Smith'