CREATE TABLE table_name_44 (opponent VARCHAR2, week VARCHAR2)

who was the opponent when the week was 9?
SELECT opponent FROM table_name_44 WHERE week = "9"
SELECT "opponent" FROM "table_name_44" WHERE "9" = "week"