SQL - List the physicians and their specialty (first name, last name, specialty) who are assigned as Surgeon. Make sure this list is distinct. [Use join query]

IlIness Diagnosis Illness Code Illness Desc Department Pres No Patient N0 Medication Code Dosage Physician JD Last Name Patient-No ness Code Tel Extensian Specialty Assignment Paticnt Medication FnysicianJD Patient No Role patient No Last Name First Name Age Gentder Medicatian Cade On Hand On Order Unit Cost