 What are the name and primarily affiliated department name of each physician?, and I want to display in ascending by the x-axis please.
CREATE TABLE Undergoes (
    Patient INTEGER,
    Procedures INTEGER,
    Stay INTEGER,
    DateUndergoes DATETIME,
    Physician INTEGER,
    AssistingNurse INTEGER
)

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

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

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

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

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

CREATE TABLE Nurse (
    EmployeeID INTEGER,
    Name VARCHAR(30),
    Position VARCHAR(30),
    Registered BOOLEAN,
    SSN INTEGER
)

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

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

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

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

CREATE TABLE Block (
    BlockFloor INTEGER,
    BlockCode INTEGER
)

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

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

CREATE TABLE Room (
    RoomNumber INTEGER,
    RoomType VARCHAR(30),
    BlockFloor INTEGER,
    BlockCode INTEGER,
    Unavailable BOOLEAN
)
SELECT T3.Name, COUNT(T3.Name) FROM Physician AS T1 JOIN Affiliated_With AS T2 ON T1.EmployeeID = T2.Physician JOIN Department AS T3 ON T2.Department = T3.DepartmentID WHERE T2.PrimaryAffiliation = 1 GROUP BY T3.Name ORDER BY T3.Name