find the names of all patients who have an undergoing treatment and are staying in room 111
select distinct t2.name from undergoes as t1 join patient as t2 on t1.patient = t2.ssn join stay as t3 on t1.stay = t3.stayid where t3.room = 111
find the name of the patient who have an insurance id 68476213
select name from patient where insuranceid = 68476213
find the name of physician who have seen the patient 100000001
select distinct physician from undergoes where patient = 100000001