How many goals were scored by the team that played less than 38 games, and had points of 47+9?
CREATE TABLE table_name_15 (goals_for INTEGER, points VARCHAR, played VARCHAR)
SELECT MAX(goals_for) FROM table_name_15 WHERE points = "47+9" AND played < 38
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_15 (goals_for INTEGER, points VARCHAR, played VARCHAR) Question: How many goals were scored by the team that played less than 38 games, and had points of 47+9? [/INST] SELECT MAX(goals_for) FROM table_name_15 WHERE points = "47+9" AND played < 38 </s>