CREATE TABLE table_name_69 (rank VARCHAR, player VARCHAR)

What ranking is james franklin?
SELECT rank FROM table_name_69 WHERE player = "james franklin"
SELECT "rank" FROM "table_name_69" WHERE "james franklin" = "player"