human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Name, Gain, Loss, Long, Avg/G
###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?
gpt
SELECT MIN Avg/G FROM table WHERE Long < 47 AND Name = frank murphy AND Gain < 569