CREATE TABLE table_204_811 (id NUMBER, "year" NUMBER, "ring name\ ( birth name ) " CLOB, "inducted by" CLOB, "inducted for" CLOB, "notes" CLOB)

how many members were inducted for announcing ?
SELECT COUNT(*) FROM table_204_811 WHERE "inducted for" = 'announcing'
SELECT COUNT(*) FROM "table_204_811" WHERE "inducted for" = 'announcing'