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