what departments are some physicians primarily affiliated with?
select distinct t2.name from affiliated_with as t1 join department as t2 on t1.department = t2.departmentid where primaryaffiliation = 1
what is the department id for surgery?
select departmentid from department where name = "Surgery"