CREATE TABLE table_name_59 (total NUMBER, silver VARCHAR2, gold VARCHAR2)

Which nation has more than 6 Silver medals and fewer than 8 Gold medals?
SELECT AVG(total) FROM table_name_59 WHERE silver > 6 AND gold < 8
SELECT AVG("total") FROM "table_name_59" WHERE "gold" < 8 AND "silver" > 6