user: ### NOW ANSWER:
Question: I want the result for goals which has goals of Deacon 6/6
Columns: ['Date', 'Competition', 'Venue', 'Result', 'Score', 'Goals']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['8/2/03', 'Cup', 'Wilderspool', 'W', '38-12', 'Deacon 7/7']
SQL:

assistant: SELECT "Result" FROM "Table" WHERE "Goals" = 'Deacon 6/6';