Database: hospital_1
Question: How many patients do each physician take care of? List their names and number of patients they take care of.
SQL:
SELECT T1.name ,  count(*) FROM physician AS T1 JOIN patient AS T2 ON T1.employeeid  =  T2.PCP GROUP BY T1.employeeid