What is the average number of bronze medals won among nations that won at least 1 medal and are not ranked 1st?
CREATE TABLE table_name_65 (bronze INTEGER, total VARCHAR, rank VARCHAR)
SELECT AVG(bronze) FROM table_name_65 WHERE total > 1 AND rank > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (bronze INTEGER, total VARCHAR, rank VARCHAR) Question: What is the average number of bronze medals won among nations that won at least 1 medal and are not ranked 1st? [/INST] SELECT AVG(bronze) FROM table_name_65 WHERE total > 1 AND rank > 1 </s>