Database: hospital_1
Question: What are the names of departments that have primarily affiliated physicians.
SQL:
SELECT DISTINCT T2.name FROM affiliated_with AS T1 JOIN department AS T2 ON T1.department = T2.departmentid WHERE PrimaryAffiliation  =  1