Find the name of physicians who are affiliated with Surgery or Psychiatry department.
SELECT T1.name FROM physician AS T1 JOIN affiliated_with AS T2 ON T1.EmployeeID  =  T2.physician JOIN department AS T3 ON T2.department  =  T3.DepartmentID WHERE T3.name  =  'Surgery' OR T3.name  =  'Psychiatry'
physicians affiliated with a department refers to a JOIN between physician, affiliated_with, and department tables; 'Surgery' or 'Psychiatry' department affiliation is determined by WHERE clause with department name;