List the physicians' employee ids together with their primary affiliation departments' ids.
CREATE TABLE affiliated_with (physician VARCHAR, department VARCHAR, primaryaffiliation VARCHAR)
[SQL] SELECT physician, department FROM affiliated_with WHERE primaryaffiliation = 1 [/SQL]