CREATE TABLE table_204_198 (id NUMBER, "club" CLOB, "nickname" CLOB, "no. of premierships" NUMBER, "premiership years" CLOB, "moved to" CLOB)

was the nickname of four corners the kangaroos or the redlegs ?
SELECT "nickname" FROM table_204_198 WHERE "club" = 'four corners'
SELECT "nickname" FROM "table_204_198" WHERE "club" = 'four corners'