CREATE TABLE table_name_95 (total INT, rank VARCHAR, bronze VARCHAR)

What is the sum of Total, when Rank is 8, and when Bronze is less than 1?
SELECT SUM(total) FROM table_name_95 WHERE rank = "8" AND bronze < 1
SELECT SUM("total") FROM "table_name_95" WHERE "8" = "rank" AND "bronze" < 1