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

in how many years has madhurima been in at least 3 films ?
SELECT COUNT(*) FROM (SELECT "year" FROM table_204_57 GROUP BY "year" HAVING COUNT("film") >= 3)
WITH "cte" AS (SELECT 1 AS "_" FROM "table_204_57" GROUP BY "year" HAVING COUNT("film") >= 3) SELECT COUNT(*) FROM "cte" "cte"