How many games were lost by more than 27 but not more 78 with goals less than 300?
CREATE TABLE table_name_61 (games INTEGER, goals_against VARCHAR, lost VARCHAR, points VARCHAR)
SELECT AVG(games) FROM table_name_61 WHERE lost > 27 AND points < 78 AND goals_against < 300
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_61 (games INTEGER, goals_against VARCHAR, lost VARCHAR, points VARCHAR) Question: How many games were lost by more than 27 but not more 78 with goals less than 300? [/INST] SELECT AVG(games) FROM table_name_61 WHERE lost > 27 AND points < 78 AND goals_against < 300 </s>