What is the average rank Finland, which has 1 bronze, more than 1 silver, and less than 0 gold, has?
CREATE TABLE table_name_6 (rank INTEGER, gold VARCHAR, nation VARCHAR, bronze VARCHAR, silver VARCHAR)
SELECT AVG(rank) FROM table_name_6 WHERE bronze = 1 AND silver > 1 AND nation = "finland" AND gold < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (rank INTEGER, gold VARCHAR, nation VARCHAR, bronze VARCHAR, silver VARCHAR) Question: What is the average rank Finland, which has 1 bronze, more than 1 silver, and less than 0 gold, has? [/INST] SELECT AVG(rank) FROM table_name_6 WHERE bronze = 1 AND silver > 1 AND nation = "finland" AND gold < 0 </s>