what is the sum of the losses when the goals against is less than 34 and the games played is less than 8?
CREATE TABLE table_name_80 (losses INTEGER, goals_against VARCHAR, games_played VARCHAR)
SELECT SUM(losses) FROM table_name_80 WHERE goals_against < 34 AND games_played < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_80 (losses INTEGER, goals_against VARCHAR, games_played VARCHAR) Question: what is the sum of the losses when the goals against is less than 34 and the games played is less than 8? [/INST] SELECT SUM(losses) FROM table_name_80 WHERE goals_against < 34 AND games_played < 8 </s>