Quantos bronzes associados a mais de 0 medalhas totais, 3 de ouro e mais de 6 jogos?
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