what is the total number of goals for when the ties is more than 0, the goals against is more than 35 and the wins is less than 2?
CREATE TABLE table_name_48 (goals_for VARCHAR, wins VARCHAR, ties VARCHAR, goals_against VARCHAR)
SELECT COUNT(goals_for) FROM table_name_48 WHERE ties > 0 AND goals_against > 35 AND wins < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (goals_for VARCHAR, wins VARCHAR, ties VARCHAR, goals_against VARCHAR) Question: what is the total number of goals for when the ties is more than 0, the goals against is more than 35 and the wins is less than 2? [/INST] SELECT COUNT(goals_for) FROM table_name_48 WHERE ties > 0 AND goals_against > 35 AND wins < 2 </s>