How many patients do each physician take care of? List their names and number of patients they take care of Show bar chart, and could you rank in descending by the bar?
CREATE TABLE Nurse (
    EmployeeID INTEGER,
    Name VARCHAR(30),
    Position VARCHAR(30),
    Registered BOOLEAN,
    SSN INTEGER
)

CREATE TABLE Room (
    RoomNumber INTEGER,
    RoomType VARCHAR(30),
    BlockFloor INTEGER,
    BlockCode INTEGER,
    Unavailable BOOLEAN
)

CREATE TABLE Stay (
    StayID INTEGER,
    Patient INTEGER,
    Room INTEGER,
    StayStart DATETIME,
    StayEnd DATETIME
)

CREATE TABLE Medication (
    Code INTEGER,
    Name VARCHAR(30),
    Brand VARCHAR(30),
    Description VARCHAR(30)
)

CREATE TABLE Appointment (
    AppointmentID INTEGER,
    Patient INTEGER,
    PrepNurse INTEGER,
    Physician INTEGER,
    Start DATETIME,
    End DATETIME,
    ExaminationRoom TEXT
)

CREATE TABLE Block (
    BlockFloor INTEGER,
    BlockCode INTEGER
)

CREATE TABLE Prescribes (
    Physician INTEGER,
    Patient INTEGER,
    Medication INTEGER,
    Date DATETIME,
    Appointment INTEGER,
    Dose VARCHAR(30)
)

CREATE TABLE Physician (
    EmployeeID INTEGER,
    Name VARCHAR(30),
    Position VARCHAR(30),
    SSN INTEGER
)

CREATE TABLE Affiliated_With (
    Physician INTEGER,
    Department INTEGER,
    PrimaryAffiliation BOOLEAN
)

CREATE TABLE Patient (
    SSN INTEGER,
    Name VARCHAR(30),
    Address VARCHAR(30),
    Phone VARCHAR(30),
    InsuranceID INTEGER,
    PCP INTEGER
)

CREATE TABLE Trained_In (
    Physician INTEGER,
    Treatment INTEGER,
    CertificationDate DATETIME,
    CertificationExpires DATETIME
)

CREATE TABLE Procedures (
    Code INTEGER,
    Name VARCHAR(30),
    Cost REAL
)

CREATE TABLE Department (
    DepartmentID INTEGER,
    Name VARCHAR(30),
    Head INTEGER
)

CREATE TABLE On_Call (
    Nurse INTEGER,
    BlockFloor INTEGER,
    BlockCode INTEGER,
    OnCallStart DATETIME,
    OnCallEnd DATETIME
)

CREATE TABLE Undergoes (
    Patient INTEGER,
    Procedures INTEGER,
    Stay INTEGER,
    DateUndergoes DATETIME,
    Physician INTEGER,
    AssistingNurse INTEGER
)
SELECT T1.Name, COUNT(*) FROM Physician AS T1 JOIN Patient AS T2 ON T1.EmployeeID = T2.PCP GROUP BY T1.EmployeeID ORDER BY T1.Name DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many patients do each physician take care of? List their names and number of patients they take care of Show bar chart, and could you rank in descending by the bar? ### Input: CREATE TABLE Nurse (
    EmployeeID INTEGER,
    Name VARCHAR(30),
    Position VARCHAR(30),
    Registered BOOLEAN,
    SSN INTEGER
)

CREATE TABLE Room (
    RoomNumber INTEGER,
    RoomType VARCHAR(30),
    BlockFloor INTEGER,
    BlockCode INTEGER,
    Unavailable BOOLEAN
)

CREATE TABLE Stay (
    StayID INTEGER,
    Patient INTEGER,
    Room INTEGER,
    StayStart DATETIME,
    StayEnd DATETIME
)

CREATE TABLE Medication (
    Code INTEGER,
    Name VARCHAR(30),
    Brand VARCHAR(30),
    Description VARCHAR(30)
)

CREATE TABLE Appointment (
    AppointmentID INTEGER,
    Patient INTEGER,
    PrepNurse INTEGER,
    Physician INTEGER,
    Start DATETIME,
    End DATETIME,
    ExaminationRoom TEXT
)

CREATE TABLE Block (
    BlockFloor INTEGER,
    BlockCode INTEGER
)

CREATE TABLE Prescribes (
    Physician INTEGER,
    Patient INTEGER,
    Medication INTEGER,
    Date DATETIME,
    Appointment INTEGER,
    Dose VARCHAR(30)
)

CREATE TABLE Physician (
    EmployeeID INTEGER,
    Name VARCHAR(30),
    Position VARCHAR(30),
    SSN INTEGER
)

CREATE TABLE Affiliated_With (
    Physician INTEGER,
    Department INTEGER,
    PrimaryAffiliation BOOLEAN
)

CREATE TABLE Patient (
    SSN INTEGER,
    Name VARCHAR(30),
    Address VARCHAR(30),
    Phone VARCHAR(30),
    InsuranceID INTEGER,
    PCP INTEGER
)

CREATE TABLE Trained_In (
    Physician INTEGER,
    Treatment INTEGER,
    CertificationDate DATETIME,
    CertificationExpires DATETIME
)

CREATE TABLE Procedures (
    Code INTEGER,
    Name VARCHAR(30),
    Cost REAL
)

CREATE TABLE Department (
    DepartmentID INTEGER,
    Name VARCHAR(30),
    Head INTEGER
)

CREATE TABLE On_Call (
    Nurse INTEGER,
    BlockFloor INTEGER,
    BlockCode INTEGER,
    OnCallStart DATETIME,
    OnCallEnd DATETIME
)

CREATE TABLE Undergoes (
    Patient INTEGER,
    Procedures INTEGER,
    Stay INTEGER,
    DateUndergoes DATETIME,
    Physician INTEGER,
    AssistingNurse INTEGER
) ### Response: SELECT T1.Name, COUNT(*) FROM Physician AS T1 JOIN Patient AS T2 ON T1.EmployeeID = T2.PCP GROUP BY T1.EmployeeID ORDER BY T1.Name DESC