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

bob caudle was an announcer , who was the other one ?
SELECT "ring name\n(birth name)" FROM table_204_811 WHERE "ring name\n(birth name)" <> 'bob caudle' AND "inducted for" = 'announcing'
SELECT "ring name\n(birth name)" FROM "table_204_811" WHERE "inducted for" = 'announcing' AND "ring name\n(birth name)" <> 'bob caudle'