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 different kit manufacturers are involved ?
SELECT COUNT(DISTINCT "kit manufacturer") FROM table_204_567
SELECT COUNT(DISTINCT "kit manufacturer") FROM "table_204_567"