CREATE TABLE table_204_7 (id NUMBER, "#" NUMBER, "date" CLOB, "film" CLOB, "gross" CLOB, "top ten places" CLOB)

which film was the highest grossing ?
SELECT "film" FROM table_204_7 ORDER BY "gross" DESC LIMIT 1
SELECT "film" FROM "table_204_7" ORDER BY "gross" DESC FETCH FIRST 1 ROWS ONLY