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

last home opponent of the season
SELECT "opponent" FROM table_204_207 WHERE "opponent" = 'home' ORDER BY "week" DESC LIMIT 1
SELECT "opponent" FROM "table_204_207" WHERE "opponent" = 'home' ORDER BY "week" DESC FETCH FIRST 1 ROWS ONLY