Goalsagainst that has a Points of 108, and a Lost smaller than 14 has what average?
CREATE TABLE table_name_40 (goalsagainst INTEGER, points VARCHAR, lost VARCHAR)
SELECT AVG(goalsagainst) FROM table_name_40 WHERE points = 108 AND lost < 14
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (goalsagainst INTEGER, points VARCHAR, lost VARCHAR) Question: Goalsagainst that has a Points of 108, and a Lost smaller than 14 has what average? [/INST] SELECT AVG(goalsagainst) FROM table_name_40 WHERE points = 108 AND lost < 14 </s>