CREATE TABLE table_204_24 (id NUMBER, "year" NUMBER, "league" CLOB, "record" CLOB, "finish" CLOB, "manager" CLOB, "playoffs" CLOB, "notes" CLOB)

were they league champions at least 5 times ?
SELECT (SELECT COUNT(*) FROM table_204_24 WHERE "playoffs" = 'league champs') >= 5
WITH "_u_0" AS (SELECT COUNT(*), 'league champs' AS "_u_1" FROM "table_204_24" GROUP BY 'league champs') SELECT COALESCE("_u_0"."", *) >= 5 LEFT JOIN "_u_0" "_u_0" ON "_u_0"."_u_1" = "playoffs"