Task: Text to Code
Input (English): What are each physician's employee id and department id primarily affiliated.
Output (English): SELECT physician ,  department FROM affiliated_with WHERE primaryaffiliation  =  1