CREATE TABLE table_204_808 (id NUMBER, "team" CLOB, "no" NUMBER, "driver" CLOB, "class" CLOB, "chassis" CLOB, "engine" CLOB)

how many teams had at least two drivers this season ?
SELECT COUNT(*) FROM (SELECT "team" FROM table_204_808 GROUP BY "team" HAVING COUNT("driver") >= 2)
WITH "cte" AS (SELECT 1 AS "_" FROM "table_204_808" GROUP BY "team" HAVING COUNT("driver") >= 2) SELECT COUNT(*) FROM "cte" "cte"