Name the total number of lost when goals scored is less than 22 and goals conceded is more than 27
CREATE TABLE table_name_82 (lost VARCHAR, goals_scored VARCHAR, goals_conceded VARCHAR)
SELECT COUNT(lost) FROM table_name_82 WHERE goals_scored < 22 AND goals_conceded > 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (lost VARCHAR, goals_scored VARCHAR, goals_conceded VARCHAR) Question: Name the total number of lost when goals scored is less than 22 and goals conceded is more than 27 [/INST] SELECT COUNT(lost) FROM table_name_82 WHERE goals_scored < 22 AND goals_conceded > 27 </s>