CREATE TABLE table_1246208_5 (goals_for VARCHAR2, club VARCHAR2)

what is the goals for when the club is new england revolution?
SELECT goals_for FROM table_1246208_5 WHERE club = "New England Revolution"
SELECT "goals_for" FROM "table_1246208_5" WHERE "New England Revolution" = "club"