CREATE TABLE table_name_48 (total VARCHAR2, silver VARCHAR2, bronze VARCHAR2, rank VARCHAR2)

How many Total(s) are there, when the number of Bronze is greater than 13, when the Rank is 8, and when the number of Silver is less than 11?
SELECT COUNT(total) FROM table_name_48 WHERE bronze > 13 AND rank = "8" AND silver < 11
SELECT COUNT("total") FROM "table_name_48" WHERE "8" = "rank" AND "bronze" > 13 AND "silver" < 11