CREATE TABLE table_204_652 (id NUMBER, "title" CLOB, "year" NUMBER, "director" CLOB, "country" CLOB, "genre" CLOB, "notes" CLOB)

which genre was used the most ?
SELECT "genre" FROM table_204_652 GROUP BY "genre" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "genre" FROM "table_204_652" GROUP BY "genre" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY