List the names of departments where some physicians are primarily affiliated with.
create table affiliated_with (department varchar, PRIMARY KEY (department)); create table department (name varchar, departmentid varchar, PRIMARY KEY (name))
select distinct t2.name from affiliated_with as t1 join department as t2 on t1.department = t2.departmentid where primaryaffiliation = 1