CREATE TABLE table_name_2 (total VARCHAR, gold VARCHAR, silver VARCHAR, rank VARCHAR)

What's the total of rank 8 when Silver medals are 0 and gold is more than 1?
SELECT COUNT(total) FROM table_name_2 WHERE silver = 0 AND rank = 8 AND gold > 1
SELECT COUNT("total") FROM "table_name_2" WHERE "gold" > 1 AND "rank" = 8 AND "silver" = 0