CREATE TABLE table_204_324 (id NUMBER, "team 1" CLOB, "agg." CLOB, "team 2" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

are there at least 4 teams in the column of team 2 ?
SELECT (SELECT COUNT("team 2") FROM table_204_324) > 4
SELECT (SELECT COUNT("team 2") FROM "table_204_324") > 4