How many goals on average are there for rank 3?
CREATE TABLE table_name_52 (goals_for INTEGER, rank VARCHAR)
SELECT AVG(goals_for) FROM table_name_52 WHERE rank = 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (goals_for INTEGER, rank VARCHAR) Question: How many goals on average are there for rank 3? [/INST] SELECT AVG(goals_for) FROM table_name_52 WHERE rank = 3 </s>