CREATE TABLE table_204_123 (id NUMBER, "week" NUMBER, "date" CLOB, "kickoff" CLOB, "opponent" CLOB, "results\ final score" CLOB, "results\ team record" CLOB, "game site" CLOB, "attendance" NUMBER)

what was the highest score achieved by rhein fire ?
SELECT MAX("results\nfinal score") FROM table_204_123 WHERE "opponent" = 'rhein fire'
SELECT MAX("results\nfinal score") FROM "table_204_123" WHERE "opponent" = 'rhein fire'