CREATE TABLE table_name_27 (bronze INT, gold VARCHAR, silver VARCHAR, total VARCHAR)

Name the average bronze with silver more than 0, total of 6 and gold more than 0
SELECT AVG(bronze) FROM table_name_27 WHERE silver > 0 AND total = 6 AND gold > 0
SELECT AVG("bronze") FROM "table_name_27" WHERE "gold" > 0 AND "silver" > 0 AND "total" = 6