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 table_name_97 (player VARCHAR, pick__number VARCHAR, mls_team VARCHAR)
  ### Question:
  Tell me the player for pick number less than 29 and mls team of chicago fire
  ### Answer:
  SELECT player FROM table_name_97 WHERE pick__number < 29 AND mls_team = "chicago fire"