Task: Text to Code
Input (English): SQL: SELECT DISTINCT Name FROM Nurse
Feedback: Change nurse nurse table with department department table and Verify it's corresponding value of primary affiliation equals 1.
Output (English): SELECT DISTINCT T2.name FROM affiliated_with AS T1 JOIN department AS T2 ON T1.department = T2.departmentid WHERE PrimaryAffiliation  =  1