Can you show me the insurance id of the patient who stays in room 111?
SELECT T2.InsuranceID 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
insurance id of the patient refers to T2.InsuranceID; patient who stays in room 111 refers to WHERE room = 111; JOIN is used to combine rows from two or more tables based on a related column between them;