CREATE TABLE table_name_44 (date VARCHAR2, week VARCHAR2, result VARCHAR2)

When was the game before week 8 with a result of bye?
SELECT date FROM table_name_44 WHERE week < 8 AND result = "bye"
SELECT "date" FROM "table_name_44" WHERE "bye" = "result" AND "week" < 8