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_82 (pick__number VARCHAR, name VARCHAR, round VARCHAR, overall VARCHAR)
  ### Question:
  Which pick number had a round of less than 7, an overall of less than 127, and where the name was Robert Alford?
  ### Answer:
  SELECT pick__number FROM table_name_82 WHERE round < 7 AND overall < 127 AND name = "robert alford"