user: ### NOW ANSWER:
Question: what is the goals for when the  club is New England Revolution?
Columns: ['Club', 'Overall Record', 'Goals For', 'Goals For Avg.', 'Goals Against', 'Goals Against Avg.']
Types: ['text', 'text', 'real', 'text', 'real', 'text']
Sample row: ['MetroStars', '11-12-7', 47.0, '1.57 (1st)', 49.0, '1.63 (10th)']
SQL:

assistant: SELECT "Goals For" FROM "Table" WHERE "Club" = 'New England Revolution';