How many games did the team lose that played 7 games and has a GA of less than 27?
CREATE TABLE table_name_1 (losses VARCHAR, games_played VARCHAR, goals_against VARCHAR)
SELECT COUNT(losses) FROM table_name_1 WHERE games_played = 7 AND goals_against < 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (losses VARCHAR, games_played VARCHAR, goals_against VARCHAR) Question: How many games did the team lose that played 7 games and has a GA of less than 27? [/INST] SELECT COUNT(losses) FROM table_name_1 WHERE games_played = 7 AND goals_against < 27 </s>