CREATE TABLE table_name_2 (date VARCHAR2, home_away_game VARCHAR2, week VARCHAR2)

What is the date of the away game in week 8?
SELECT date FROM table_name_2 WHERE home_away_game = "away" AND week = 8
SELECT "date" FROM "table_name_2" WHERE "away" = "home_away_game" AND "week" = 8