CREATE TABLE table_14705 ("Rank" CLOB, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What nation had more than 97 Gold Medals and fewer than 332 Silver Medals?
SELECT SUM("Total") FROM table_14705 WHERE "Gold" > '97' AND "Silver" < '332'
SELECT SUM("Total") FROM "table_14705" WHERE "Gold" > '97' AND "Silver" < '332'