CREATE TABLE table_204_662 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "result" CLOB, "attendance" NUMBER, "bye" CLOB)

what week was the bye after ?
SELECT "week" FROM table_204_662 WHERE id = (SELECT id FROM table_204_662 WHERE "bye" = 1) - 1
SELECT "week" FROM "table_204_662" WHERE "id" = (SELECT "id" FROM "table_204_662" WHERE "bye" = 1) - 1