How many patients are there?
select count ( * ) from patient
Can you show me the name of the patient who stays in room 111?
select t2.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
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