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

are there more films in 2008 or 2005 ?
SELECT "year" FROM table_204_647 WHERE "year" IN (2008, 2005) GROUP BY "year" ORDER BY COUNT("film") DESC LIMIT 1
SELECT "year" FROM "table_204_647" WHERE "year" IN (2008, 2005) GROUP BY "year" ORDER BY COUNT("film") DESC FETCH FIRST 1 ROWS ONLY