CREATE TABLE table_name_86 (avg_g INTEGER, gain VARCHAR, long VARCHAR, name VARCHAR)
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?
SELECT MIN(avg_g) FROM table_name_86 WHERE long < 47 AND name = "frank murphy" AND gain < 569