CREATE TABLE table_name_96 (gold VARCHAR2, total VARCHAR2, rank VARCHAR2)

What's the total number of gold where the total is less than 23 and the rank is over 10?
SELECT COUNT(gold) FROM table_name_96 WHERE total < 23 AND rank > 10
SELECT COUNT("gold") FROM "table_name_96" WHERE "rank" > 10 AND "total" < 23