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

did the team place higher in the 2002-03 season or the 2003-04 season ?
SELECT "season" FROM table_204_589 WHERE "season" IN ('2002-03', '2003-04') ORDER BY "pos." LIMIT 1
SELECT "season" FROM "table_204_589" WHERE "season" IN ('2002-03', '2003-04') ORDER BY "pos." FETCH FIRST 1 ROWS ONLY