What is the average number of silver medals of the nation with 3 bronzes and more than 4 total medals?
CREATE TABLE table_name_79 (silver INTEGER, bronze VARCHAR, total VARCHAR)
SELECT AVG(silver) FROM table_name_79 WHERE bronze = 3 AND total > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (silver INTEGER, bronze VARCHAR, total VARCHAR) Question: What is the average number of silver medals of the nation with 3 bronzes and more than 4 total medals? [/INST] SELECT AVG(silver) FROM table_name_79 WHERE bronze = 3 AND total > 4 </s>