How many goals were there in game 47?
CREATE TABLE table_name_29 (goals VARCHAR, games VARCHAR)
SELECT goals FROM table_name_29 WHERE games = "47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (goals VARCHAR, games VARCHAR) Question: How many goals were there in game 47? [/INST] SELECT goals FROM table_name_29 WHERE games = "47" </s>