CREATE TABLE table_name_2 (gold NUMBER, silver VARCHAR2, total VARCHAR2, rank VARCHAR2)

Total larger than 3, and a Rank of 4, and a Silver larger than 0 has what average gold?
SELECT AVG(gold) FROM table_name_2 WHERE total > 3 AND rank = "4" AND silver > 0
SELECT AVG("gold") FROM "table_name_2" WHERE "4" = "rank" AND "silver" > 0 AND "total" > 3