Database: hospital_1
Question: List the physicians' employee ids together with their primary affiliation departments' ids.
SQL:
SELECT physician ,  department FROM affiliated_with WHERE primaryaffiliation  =  1