CREATE TABLE table_204_567 (id NUMBER, "team" CLOB, "location" CLOB, "stadium" CLOB, "capacity" NUMBER, "manager" CLOB, "captain" CLOB, "kit manufacturer" CLOB, "shirt sponsor" CLOB)

how many stadiums have a capacity of at least 8,000 ?
SELECT COUNT("stadium") FROM table_204_567 WHERE "capacity" >= 8000
SELECT COUNT("stadium") FROM "table_204_567" WHERE "capacity" >= 8000