10) List the physicians and their specialty (first name, last name, specialty, specialty location) who are assigned as Primary Care. Make sure this list is distinct. [Use join query] Construct SQL CODE queries to answer this question!

E Assignment Diagnosis lines s Medication Patient Physician E Prescription E Specialty Relationships Diagnosis lllness Patient No Illness-Code Physician ID Patient-No Role lilness Code Illness Dese Department Patient Patient No Last, Name First Name Gender Age Admit Date Bed Assignment Physician Physician_ID Last Name First Name TeLExtension Specialty ID Specielty 5peciht.ID Specialty Meditation Code Medication Desc On Hand On Order Unit Cost Prescription Pres No Patient No Medication Code Dosage