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_86 (avg_g INTEGER, gain VARCHAR, long VARCHAR, name VARCHAR)
  ### Question:
  Which Avg/G is the lowest one that has a Long smaller than 47, and a Name of frank murphy, and a Gain smaller than 569?
  ### Answer:
  SELECT MIN(avg_g) FROM table_name_86 WHERE long < 47 AND name = "frank murphy" AND gain < 569