CREATE TABLE table_204_7 (id DECIMAL, "#" DECIMAL, "date" TEXT, "film" TEXT, "gross" TEXT, "top ten places" TEXT)

which movies were number 1 for at least two consecutive weeks ?
SELECT "film" FROM table_204_7 GROUP BY "film" HAVING COUNT(*) >= 2
SELECT "film" FROM "table_204_7" GROUP BY "film" HAVING COUNT(*) >= 2