CREATE TABLE table_204_524 (id NUMBER, "season" CLOB, "tier" NUMBER, "division" CLOB, "place" CLOB)

what the tier before 2006/7 ?
SELECT "tier" FROM table_204_524 WHERE "season" < '2006/07' ORDER BY "season" DESC LIMIT 1
SELECT "tier" FROM "table_204_524" WHERE "season" < '2006/07' ORDER BY "season" DESC FETCH FIRST 1 ROWS ONLY