CREATE TABLE patient (PCP VARCHAR2)
CREATE TABLE physician (name VARCHAR2, employeeid VARCHAR2)

Find the name of physicians who are in charge of more than one patient.
SELECT T1.name FROM physician AS T1 JOIN patient AS T2 ON T1.employeeid = T2.PCP GROUP BY T1.employeeid HAVING COUNT(*) > 1
SELECT "T1"."name" FROM "physician" "T1" JOIN "patient" "T2" ON "T1"."employeeid" = "T2"."PCP" GROUP BY "T1"."employeeid" HAVING COUNT(*) > 1