CREATE TABLE table_name_51 (date VARCHAR2, rank__number VARCHAR2)

WHAT DATE HAD 6 RANK?
SELECT date FROM table_name_51 WHERE rank__number = "6"
SELECT "date" FROM "table_name_51" WHERE "6" = "rank__number"