CREATE TABLE Stay (StayID INT, Patient INT, Room INT, StayStart DATETIME, StayEnd DATETIME)
CREATE TABLE Patient (SSN INT, Name VARCHAR, Address VARCHAR, Phone VARCHAR, InsuranceID INT, PCP INT)
CREATE TABLE Physician (EmployeeID INT, Name VARCHAR, Position VARCHAR, SSN INT)
CREATE TABLE Appointment (AppointmentID INT, Patient INT, PrepNurse INT, Physician INT, Start DATETIME, End DATETIME, ExaminationRoom TEXT)
CREATE TABLE Undergoes (Patient INT, Procedures INT, Stay INT, DateUndergoes DATETIME, Physician INT, AssistingNurse INT)
CREATE TABLE Trained_In (Physician INT, Treatment INT, CertificationDate DATETIME, CertificationExpires DATETIME)
CREATE TABLE Medication (Code INT, Name VARCHAR, Brand VARCHAR, Description VARCHAR)
CREATE TABLE Department (DepartmentID INT, Name VARCHAR, Head INT)
CREATE TABLE Prescribes (Physician INT, Patient INT, Medication INT, Date DATETIME, Appointment INT, Dose VARCHAR)
CREATE TABLE Nurse (EmployeeID INT, Name VARCHAR, Position VARCHAR, Registered BOOLEAN, SSN INT)
CREATE TABLE Procedures (Code INT, Name VARCHAR, Cost FLOAT)
CREATE TABLE Room (RoomNumber INT, RoomType VARCHAR, BlockFloor INT, BlockCode INT, Unavailable BOOLEAN)
CREATE TABLE On_Call (Nurse INT, BlockFloor INT, BlockCode INT, OnCallStart DATETIME, OnCallEnd DATETIME)
CREATE TABLE Affiliated_With (Physician INT, Department INT, PrimaryAffiliation BOOLEAN)
CREATE TABLE Block (BlockFloor INT, BlockCode INT)

Return the name of each physician and the number of patients he or she treats in a bar chart.
SELECT T1.Name, COUNT(*) FROM Physician AS T1 JOIN Patient AS T2 ON T1.EmployeeID = T2.PCP GROUP BY T1.EmployeeID
SELECT "T1"."Name", COUNT(*) FROM "Physician" AS "T1" JOIN "Patient" AS "T2" ON "T1"."EmployeeID" = "T2"."PCP" GROUP BY "T1"."EmployeeID"