ค้นหาชื่อแพทย์ที่อยู่สังกัดทั้งแผนกศัลยศาสตร์และจิตเวชศาสตร์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Find the name of physicians who are affiliated with both Surgery and Psychiatry departments.It is not neccessary to use all the tables.
 affiliated_with:  (physician [ VARCHAR ] department [ VARCHAR) ]
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'