CREATE TABLE affiliated_with (physician VARCHAR2, department VARCHAR2)
CREATE TABLE department (DepartmentID VARCHAR2, name VARCHAR2)
CREATE TABLE physician (name VARCHAR2, EmployeeID VARCHAR2)

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'
SELECT "T1"."name" FROM "physician" "T1" JOIN "affiliated_with" "T2" ON "T1"."EmployeeID" = "T2"."physician" JOIN "department" "T3" ON "T2"."department" = "T3"."DepartmentID" AND ("T3"."name" = 'Psychiatry' OR "T3"."name" = 'Surgery')