CREATE TABLE table_203_664 (id NUMBER, "club" CLOB, "town" CLOB, "founded" NUMBER, "nickname" CLOB, "colours" CLOB, "home ground" CLOB, "titles" NUMBER, "website" CLOB)

which clubs have no nickname ?
SELECT "club" FROM table_203_664 WHERE "nickname" IS NULL
SELECT "club" FROM "table_203_664" WHERE "nickname" IS NULL