Database: hospital_1
Question: What are each physician's employee id and department id primarily affiliated.
SQL:
SELECT physician ,  department FROM affiliated_with WHERE primaryaffiliation  =  1