Find the name of physicians who are in charge of more than one patient.
create table patient (pcp varchar, PRIMARY KEY (pcp)); create table physician (name varchar, employeeid varchar, PRIMARY KEY (name))
select t1.name from physician as t1 join patient as t2 on t1.employeeid = t2.pcp group by t1.employeeid having count(*) > 1