What average total has a gold greater than 0, and a silver greater than 0, with a bronze greater than 2?
CREATE TABLE table_name_9 (total INTEGER, bronze VARCHAR, gold VARCHAR, silver VARCHAR)
SELECT AVG(total) FROM table_name_9 WHERE gold > 0 AND silver > 0 AND bronze > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (total INTEGER, bronze VARCHAR, gold VARCHAR, silver VARCHAR) Question: What average total has a gold greater than 0, and a silver greater than 0, with a bronze greater than 2? [/INST] SELECT AVG(total) FROM table_name_9 WHERE gold > 0 AND silver > 0 AND bronze > 2 </s>