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

what was the total gross of frozen when it was number one ?
SELECT SUM("gross") FROM table_204_7 WHERE "film" = 'frozen'
SELECT SUM("gross") FROM "table_204_7" WHERE "film" = 'frozen'