CREATE TABLE table_204_667 (id NUMBER, "year" NUMBER, "film title" CLOB, "genre" CLOB, "cast" CLOB, "notes" CLOB)

which genre appears the most on this chart ?
SELECT "genre" FROM table_204_667 GROUP BY "genre" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "genre" FROM "table_204_667" GROUP BY "genre" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY