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

who has more premierships , four corners or west milby ?
SELECT "club" FROM table_204_198 WHERE "club" IN ('four corners', 'west milby') ORDER BY "no. of premierships" DESC LIMIT 1
SELECT "club" FROM "table_204_198" WHERE "club" IN ('four corners', 'west milby') ORDER BY "no. of premierships" DESC FETCH FIRST 1 ROWS ONLY