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

What are the name and primarily affiliated department name of each physician?, and I want to display in ascending by the x-axis please.
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
SELECT "T3"."Name", COUNT("T3"."Name") FROM "Physician" "T1" JOIN "Affiliated_With" "T2" ON "T1"."EmployeeID" = "T2"."Physician" AND "T2"."PrimaryAffiliation" = 1 JOIN "Department" "T3" ON "T2"."Department" = "T3"."DepartmentID" GROUP BY "T3"."Name" ORDER BY "T3"."Name"