CREATE TABLE table_name_77 (rank VARCHAR, athlete VARCHAR, total VARCHAR)

how many times is the athlete jin di and the total less than 118?
SELECT COUNT(rank) FROM table_name_77 WHERE athlete = "jin di" AND total < 118
SELECT COUNT("rank") FROM "table_name_77" WHERE "athlete" = "jin di" AND "total" < 118