CREATE TABLE table_204_792 (id NUMBER, "#" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "win" CLOB, "loss" CLOB, "save" CLOB, "attendance" NUMBER, "record" CLOB)

who did the astros play after the reds ?
SELECT "opponent" FROM table_204_792 WHERE "#" > (SELECT MAX("#") FROM table_204_792 WHERE "opponent" = 'reds') ORDER BY "#" LIMIT 1
SELECT "opponent" FROM "table_204_792" WHERE "#" > (SELECT MAX("#") FROM "table_204_792" WHERE "opponent" = 'reds') ORDER BY "#" FETCH FIRST 1 ROWS ONLY