CREATE TABLE table_name_24 (date VARCHAR2, rank__number VARCHAR2, opponent_number VARCHAR2)

On what date was the game played where the opponent was Stanford, ranked #5?
SELECT date FROM table_name_24 WHERE rank__number = "5" AND opponent_number = "stanford"
SELECT "date" FROM "table_name_24" WHERE "5" = "rank__number" AND "opponent_number" = "stanford"