Database: hospital_1
Question: Return the name of each physician and the number of patients he or she treats.
SQL:
SELECT T1.name ,  count(*) FROM physician AS T1 JOIN patient AS T2 ON T1.employeeid  =  T2.PCP GROUP BY T1.employeeid