I would like to know the names of all the physicians
select name from physician
if you could please share the average total patient per physician the would be helpful.
select t1.name, count ( * ) from physician as t1 join patient as t2 on t1.employeeid = t2.pcp group by t1.employeeid
which of the physicians have zero patients?
select name from physician where name not in ( select t1.name from physician as t1 join patient as t2 on t1.employeeid = t2.pcp )