CREATE TABLE table_204_864 (id NUMBER, "pos" NUMBER, "class" CLOB, "no" NUMBER, "team" CLOB, "drivers" CLOB, "chassis" CLOB, "engine" CLOB)

tell me an engine that was used by at least 3 different teams .
SELECT "engine" FROM table_204_864 GROUP BY "engine" HAVING COUNT("team") >= 3
SELECT "engine" FROM "table_204_864" GROUP BY "engine" HAVING COUNT("team") >= 3