How many goals against were scored when the goals for is less than 48 with 0 ties?
CREATE TABLE table_name_65 (goals_against VARCHAR, goals_for VARCHAR, ties VARCHAR)
SELECT COUNT(goals_against) FROM table_name_65 WHERE goals_for < 48 AND ties < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (goals_against VARCHAR, goals_for VARCHAR, ties VARCHAR) Question: How many goals against were scored when the goals for is less than 48 with 0 ties? [/INST] SELECT COUNT(goals_against) FROM table_name_65 WHERE goals_for < 48 AND ties < 0 </s>