What is the average Silver with rank 30 and a Bronze greater than 0
CREATE TABLE table_name_42 (silver INTEGER, rank VARCHAR, bronze VARCHAR)
SELECT AVG(silver) FROM table_name_42 WHERE rank = "30" AND bronze > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (silver INTEGER, rank VARCHAR, bronze VARCHAR) Question: What is the average Silver with rank 30 and a Bronze greater than 0 [/INST] SELECT AVG(silver) FROM table_name_42 WHERE rank = "30" AND bronze > 0 </s>