CREATE TABLE table_204_589 (id NUMBER, "season" CLOB, "tier" NUMBER, "division" CLOB, "pos." CLOB, "notes" CLOB)

does honor b or asobal have the larger tier ?
SELECT "division" FROM table_204_589 WHERE "division" IN ('honor b', 'asobal') ORDER BY "tier" DESC LIMIT 1
SELECT "division" FROM "table_204_589" WHERE "division" IN ('honor b', 'asobal') ORDER BY "tier" DESC FETCH FIRST 1 ROWS ONLY