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

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