CREATE TABLE table_204_173 (id NUMBER, "rank" NUMBER, "group" CLOB, "name" CLOB, "nationality" CLOB, "2.05" CLOB, "2.15" CLOB, "2.19" CLOB, "2.23" CLOB, "2.26" CLOB, "result" CLOB, "notes" CLOB)

which names are not in group a ?
SELECT "name" FROM table_204_173 WHERE "group" <> 'a'
SELECT "name" FROM "table_204_173" WHERE "group" <> 'a'