user: 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?
Columns: ['Name', 'Gain', 'Loss', 'Long', 'Avg/G']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Joe Hall', 628.0, 15.0, 47.0, 68.1]
SQL:

assistant: SELECT MIN("Avg/G") FROM "Table" WHERE "Long" < 47.0 AND "Name" = 'frank murphy' AND "Gain" < 569.0;