How many goals have a goal ration less than 0.8 with 56 games?
CREATE TABLE table_name_49 (goals VARCHAR, goal_ratio VARCHAR, games VARCHAR)
SELECT COUNT(goals) FROM table_name_49 WHERE goal_ratio < 0.8 AND games = 56
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_49 (goals VARCHAR, goal_ratio VARCHAR, games VARCHAR) Question: How many goals have a goal ration less than 0.8 with 56 games? [/INST] SELECT COUNT(goals) FROM table_name_49 WHERE goal_ratio < 0.8 AND games = 56 </s>