How many average gold medals for provinces higher than rank 9 with 25 bronzes?
CREATE TABLE table_name_26 (gold INTEGER, bronze VARCHAR, rank VARCHAR)
SELECT AVG(gold) FROM table_name_26 WHERE bronze = 25 AND rank < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (gold INTEGER, bronze VARCHAR, rank VARCHAR) Question: How many average gold medals for provinces higher than rank 9 with 25 bronzes? [/INST] SELECT AVG(gold) FROM table_name_26 WHERE bronze = 25 AND rank < 9 </s>