What is the mean rank number when goals are 230 and there are more than 535?
CREATE TABLE table_name_86 (rank INTEGER, goals VARCHAR, matches VARCHAR)
SELECT AVG(rank) FROM table_name_86 WHERE goals = 230 AND matches > 535
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (rank INTEGER, goals VARCHAR, matches VARCHAR) Question: What is the mean rank number when goals are 230 and there are more than 535? [/INST] SELECT AVG(rank) FROM table_name_86 WHERE goals = 230 AND matches > 535 </s>