What is the average Gold when silver is more than 2, and bronze is more than 1
CREATE TABLE table_name_59 (gold INTEGER, silver VARCHAR, bronze VARCHAR)
SELECT AVG(gold) FROM table_name_59 WHERE silver > 2 AND bronze > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (gold INTEGER, silver VARCHAR, bronze VARCHAR) Question: What is the average Gold when silver is more than 2, and bronze is more than 1 [/INST] SELECT AVG(gold) FROM table_name_59 WHERE silver > 2 AND bronze > 1 </s>