CREATE TABLE table_name_15 (total NUMBER, silver VARCHAR2, bronze VARCHAR2)

Can you tell me the average Total that has the Silver larger than 1, and the Bronze smaller than 8?
SELECT AVG(total) FROM table_name_15 WHERE silver > 1 AND bronze < 8
SELECT AVG("total") FROM "table_name_15" WHERE "bronze" < 8 AND "silver" > 1