WHAT IS THE AVERAGE NANGUN WITH A RANK LARGER THAN 2, TOTAL OF 17.85?
CREATE TABLE table_name_80 (nangun INTEGER, rank VARCHAR, total VARCHAR)
SELECT AVG(nangun) FROM table_name_80 WHERE rank > 2 AND total = 17.85
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_80 (nangun INTEGER, rank VARCHAR, total VARCHAR) Question: WHAT IS THE AVERAGE NANGUN WITH A RANK LARGER THAN 2, TOTAL OF 17.85? [/INST] SELECT AVG(nangun) FROM table_name_80 WHERE rank > 2 AND total = 17.85 </s>