CREATE TABLE table_name_32 (rank VARCHAR, total VARCHAR, silver VARCHAR, bronze VARCHAR)

What rank is the team with 1 silver, 3 bronze and a total of less than 8 medals?
SELECT COUNT(rank) FROM table_name_32 WHERE silver = 1 AND bronze = 3 AND total < 8
SELECT COUNT("rank") FROM "table_name_32" WHERE "bronze" = 3 AND "silver" = 1 AND "total" < 8