CREATE TABLE table_204_723 (id NUMBER, "year" NUMBER, "film" CLOB, "role" CLOB, "notes" CLOB)

how many films were made 1992 ?
SELECT COUNT("film") FROM table_204_723 WHERE "year" = 1992
SELECT COUNT("film") FROM "table_204_723" WHERE "year" = 1992