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

how long was frozen number one ?
SELECT COUNT(*) FROM table_204_7 WHERE "film" = 'frozen'
SELECT COUNT(*) FROM "table_204_7" WHERE "film" = 'frozen'