CREATE TABLE table_name_26 (total NUMBER, gold VARCHAR2, bronze VARCHAR2, silver VARCHAR2)

What is the average total number of medals when there were 4 bronze, more than 2 silver, and less than 7 gold medals?
SELECT AVG(total) FROM table_name_26 WHERE bronze = 4 AND silver > 2 AND gold < 7
SELECT AVG("total") FROM "table_name_26" WHERE "bronze" = 4 AND "gold" < 7 AND "silver" > 2