CREATE TABLE table_name_96 (bronze INT, total VARCHAR, silver VARCHAR)

Tell me the average bronze for total less than 4 and silver more than 0
SELECT AVG(bronze) FROM table_name_96 WHERE total < 4 AND silver > 0
SELECT AVG("bronze") FROM "table_name_96" WHERE "silver" > 0 AND "total" < 4