CREATE TABLE table_204_647 (id NUMBER, "year" NUMBER, "film" CLOB, "role" CLOB, "language" CLOB)

how many films were made in 2008
SELECT COUNT("film") FROM table_204_647 WHERE "year" = 2008
SELECT COUNT("film") FROM "table_204_647" WHERE "year" = 2008