How many patients is each physician in change of?
select count(*) from physician as t1 join patient as t2 on t1.employeeid = t2.pcp group by t1.employeeid
Which physicians are in charge of more than one?
select * from physician as t1 join patient as t2 on t1.employeeid = t2.pcp group by t1.employeeid having count(*) > 1
What are the name of these physicians?
select t1.name from physician as t1 join patient as t2 on t1.employeeid = t2.pcp group by t1.employeeid having count(*) > 1