Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
### Context:
CREATE TABLE affiliated_with (physician VARCHAR, department VARCHAR, primaryaffiliation VARCHAR)
### Question:
List the physicians' employee ids together with their primary affiliation departments' ids.
### Answer:
SELECT physician, department FROM affiliated_with WHERE primaryaffiliation = 1