CREATE TABLE table_name_99 (rank NUMBER, gold VARCHAR2, total VARCHAR2)

What is the total of rank when gold is 2 and total is more than 4?
SELECT SUM(rank) FROM table_name_99 WHERE gold = 2 AND total > 4
SELECT SUM("rank") FROM "table_name_99" WHERE "gold" = 2 AND "total" > 4