What is the sum of Goals, when Season is "2005-06", and when Division is less than 1?
CREATE TABLE table_name_43 (goals INTEGER, season VARCHAR, division VARCHAR)
SELECT SUM(goals) FROM table_name_43 WHERE season = "2005-06" AND division < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (goals INTEGER, season VARCHAR, division VARCHAR) Question: What is the sum of Goals, when Season is "2005-06", and when Division is less than 1? [/INST] SELECT SUM(goals) FROM table_name_43 WHERE season = "2005-06" AND division < 1 </s>