List the physicians' employee ids together with their primary affiliation departments' ids.
select physician, department from affiliated_with where primaryaffiliation = 1