CREATE TABLE table_name_44 (silver NUMBER, bronze VARCHAR2, rank VARCHAR2, total VARCHAR2)

What is the average silver for a rank less than 8, were there were no more than 4 bronze and 12 in total?
SELECT AVG(silver) FROM table_name_44 WHERE rank < 8 AND total = 12 AND bronze < 4
SELECT AVG("silver") FROM "table_name_44" WHERE "bronze" < 4 AND "rank" < 8 AND "total" = 12