CREATE TABLE table_name_74 (total INT, rank VARCHAR, gold VARCHAR)

What is the sum of Total ranking 9 and a Gold more than 6
SELECT SUM(total) FROM table_name_74 WHERE rank = "9" AND gold > 6
SELECT SUM("total") FROM "table_name_74" WHERE "9" = "rank" AND "gold" > 6