List the physicians' employee ids together with their primary affiliation departments' ids.
CREATE TABLE affiliated_with (physician VARCHAR, department VARCHAR, primaryaffiliation VARCHAR)
SELECT physician, department FROM affiliated_with WHERE primaryaffiliation = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE affiliated_with (physician VARCHAR, department VARCHAR, primaryaffiliation VARCHAR) Question: List the physicians' employee ids together with their primary affiliation departments' ids. [/INST] SELECT physician, department FROM affiliated_with WHERE primaryaffiliation = 1 </s>