How many points are there when they have under 27 goals scored, conceded 24 goals, and lost less than 6 times?
CREATE TABLE table_name_40 (points INTEGER, lost VARCHAR, goals_scored VARCHAR, goals_conceded VARCHAR)
SELECT SUM(points) FROM table_name_40 WHERE goals_scored < 27 AND goals_conceded = 24 AND lost < 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (points INTEGER, lost VARCHAR, goals_scored VARCHAR, goals_conceded VARCHAR) Question: How many points are there when they have under 27 goals scored, conceded 24 goals, and lost less than 6 times? [/INST] SELECT SUM(points) FROM table_name_40 WHERE goals_scored < 27 AND goals_conceded = 24 AND lost < 6 </s>