CREATE TABLE affiliated_with (physician VARCHAR(255), department VARCHAR(255)); CREATE TABLE department (DepartmentID VARCHAR(255), name VARCHAR(255)); CREATE TABLE physician (name VARCHAR(255), EmployeeID VARCHAR(255))
Find the name of physicians who are affiliated with both Surgery and Psychiatry departments.
    
SQL: 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' INTERSECT 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 = 'Psychiatry'