CREATE TABLE table_204_24 (id NUMBER, "year" NUMBER, "league" CLOB, "record" CLOB, "finish" CLOB, "manager" CLOB, "playoffs" CLOB, "notes" CLOB)

who was the previous manager of the california league before ray perry ?
SELECT "manager" FROM table_204_24 WHERE "league" = 'california league' AND "year" < (SELECT "year" FROM table_204_24 WHERE "manager" = 'ray perry') ORDER BY id DESC LIMIT 1
SELECT "manager" FROM "table_204_24" WHERE "league" = 'california league' AND "year" < (SELECT "year" FROM "table_204_24" WHERE "manager" = 'ray perry') ORDER BY "id" DESC FETCH FIRST 1 ROWS ONLY