text: 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