How many patients do each physician take care of? List their names and number of patients they take care of.
SELECT T1.name ,  count(*) FROM physician AS T1 JOIN patient AS T2 ON T1.employeeid  =  T2.PCP GROUP BY T1.employeeid
number of patients each physician takes care of refers to COUNT(*) GROUP BY physician_id; physician's name refers to T1.name; physician and patient relationship is determined by physician.employeeid = patient.PCP;