CREATE TABLE table_name_70 (bronze NUMBER, silver VARCHAR2, total VARCHAR2, rank VARCHAR2, gold VARCHAR2)

How many Bronze medals were received by the nation that Ranked less than 5 and received more than 2 Gold medals, less than 4 Silver medals with a Total of 9 medals?
SELECT AVG(bronze) FROM table_name_70 WHERE rank < 5 AND gold > 2 AND total = 9 AND silver < 4
SELECT AVG("bronze") FROM "table_name_70" WHERE "gold" > 2 AND "rank" < 5 AND "silver" < 4 AND "total" = 9