what is the goals for when the  club is new england revolution?
CREATE TABLE table_1246208_5 (goals_for VARCHAR, club VARCHAR)
SELECT goals_for FROM table_1246208_5 WHERE club = "New England Revolution"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1246208_5 (goals_for VARCHAR, club VARCHAR) Question: what is the goals for when the  club is new england revolution? [/INST] SELECT goals_for FROM table_1246208_5 WHERE club = "New England Revolution" </s>