what is the goals for when the club is new england revolution?
CREATE TABLE table_17692 (
    "Club" text,
    "Overall Record" text,
    "Goals For" real,
    "Goals For Avg." text,
    "Goals Against" real,
    "Goals Against Avg." text
)
SELECT "Goals For" FROM table_17692 WHERE "Club" = 'New England Revolution'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the goals for when the club is new england revolution? ### Input: CREATE TABLE table_17692 (
    "Club" text,
    "Overall Record" text,
    "Goals For" real,
    "Goals For Avg." text,
    "Goals Against" real,
    "Goals Against Avg." text
) ### Response: SELECT "Goals For" FROM table_17692 WHERE "Club" = 'New England Revolution'