แพทย์คนไหนสังกัดแผนกศัลยกรรมหรือจิตเวชบ้าง? บอกชื่อมาหน่อย ไม่จำเป็นต้องใช้ทุกตาราง
Which physicians are affiliated with either Surgery or Psychiatry department? Give me their names.It is not neccessary to use all the tables.
 affiliated_with:  physician [ number]  department [ number]  primaryaffiliation [ boolean] 
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'