What is the average number of gold medals won among the nations that won more than 1 bronze?
CREATE TABLE table_name_40 (gold INTEGER, bronze INTEGER)
SELECT AVG(gold) FROM table_name_40 WHERE bronze > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (gold INTEGER, bronze INTEGER) Question: What is the average number of gold medals won among the nations that won more than 1 bronze? [/INST] SELECT AVG(gold) FROM table_name_40 WHERE bronze > 1 </s>