I am stumped with the sort piece of this question. I have ORDER BY LastName. Do I need to identify 

List the first and last names of all physicians together with the first and last names of all their patients. Sort the list by the last name of the physician, and the last name of the patient. Avoid listing duplications of pairs of physicians and patients' names.

 

SELECT FirstName , LastName 

FROM Physician, Patient

WHERE Catergory =  LastName FROM Physician AND Patient

ORDER BY LastName 

Transcribed Image Text:

Clinical Tests TestID Name RequestedClinical Tests ConsultationID TestID 8 Description UnitCost Physician FirstName LastName ID Specialty Phone Salary Date Result 1 Medication ConsultationID MedicationID Dosage DosageUnit Quantity UnitCost 1 Medicine MedicationID Name Indications Contraindications Consultation ConsultationID PhysicianID PatientSSN Date 8 Patient SSN FollowUp ConsultationID Item Diagnosis Treatment FirstName LastName Insurance No DOB Clinical Tests TestID Name RequestedClinical Tests ConsultationID TestID 8 Description UnitCost Physician FirstName LastName ID Specialty Phone Salary Date Result 1 Medication ConsultationID MedicationID Dosage DosageUnit Quantity UnitCost 1 Medicine MedicationID Name Indications Contraindications Consultation ConsultationID PhysicianID PatientSSN Date 8 Patient SSN FollowUp ConsultationID Item Diagnosis Treatment FirstName LastName Insurance No DOB