List the physicians' employee ids together with their primary affiliation departments' ids.
create table affiliated_with (physician varchar, department varchar, primaryaffiliation varchar, PRIMARY KEY (physician))
select physician, department from affiliated_with where primaryaffiliation = 1