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)

the stadium can only hold 2500 people .
SELECT "stadium" FROM table_204_567 WHERE "capacity" = 2500
SELECT "stadium" FROM "table_204_567" WHERE "capacity" = 2500