How many bronzes associated with over 0 total medals, 3 golds, and over 6 games?
CREATE TABLE table_name_9 (bronze INTEGER, games VARCHAR, total VARCHAR, gold VARCHAR)
SELECT AVG(bronze) FROM table_name_9 WHERE total > 0 AND gold = 3 AND games > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (bronze INTEGER, games VARCHAR, total VARCHAR, gold VARCHAR) Question: How many bronzes associated with over 0 total medals, 3 golds, and over 6 games? [/INST] SELECT AVG(bronze) FROM table_name_9 WHERE total > 0 AND gold = 3 AND games > 6 </s>