Tell me the totla number of goal difference for goals against of 30 and played less than 18
CREATE TABLE table_name_4 (goal_difference VARCHAR, goals_against VARCHAR, played VARCHAR)
SELECT COUNT(goal_difference) FROM table_name_4 WHERE goals_against = 30 AND played < 18
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (goal_difference VARCHAR, goals_against VARCHAR, played VARCHAR) Question: Tell me the totla number of goal difference for goals against of 30 and played less than 18 [/INST] SELECT COUNT(goal_difference) FROM table_name_4 WHERE goals_against = 30 AND played < 18 </s>