What is the average Gold, when Silver is less than 107, when Bronze is greater than 42, and when Rank is 3?
CREATE TABLE table_name_95 (gold INTEGER, rank VARCHAR, silver VARCHAR, bronze VARCHAR)
SELECT AVG(gold) FROM table_name_95 WHERE silver < 107 AND bronze > 42 AND rank = "3"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (gold INTEGER, rank VARCHAR, silver VARCHAR, bronze VARCHAR) Question: What is the average Gold, when Silver is less than 107, when Bronze is greater than 42, and when Rank is 3? [/INST] SELECT AVG(gold) FROM table_name_95 WHERE silver < 107 AND bronze > 42 AND rank = "3" </s>