Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Nomeie a média de bronze com prata superior a 0, total de 6 e ouro superior a 0.
 ###Tabelas: CREATE TABLE performance_by_nation (performance_by_nation_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE preliminary_competition (preliminary_competition_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Interview INT, Swimsuit INT, Evening gown INT, Average INT) CREATE TABLE notes_and_references (notes_and_references_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Total INT, Crimean War INT, Persian War INT, Indian Mutiny INT, 1860-1878 INT, Zulu War INT, Second Afghan War VARCHAR) CREATE TABLE table_of_world_organization_of_the_scout_movement_members (table_of_world_organization_of_the_scout_movement_members_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Membership (from 2010) INT, Name of member organization VARCHAR, Year current Scouting organization joined WOSM VARCHAR, Year member organization was founded VARCHAR, Admits boys/girls VARCHAR) CREATE TABLE villages (villages_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Faith VARCHAR, Type VARCHAR, Intake INT, DCSF number INT, Ofsted number INT)  
SELECT AVG Bronze FROM performance_by_nation WHERE Silver > 0 AND Total = 6 AND Gold > 0