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