CREATE TABLE table_204_529 (id NUMBER, "year" NUMBER, "personnel" CLOB, "album" CLOB, "label" CLOB, "peak positions\ nor" NUMBER)

which album did she produce before good rain ?
SELECT "album" FROM table_204_529 WHERE id = (SELECT id FROM table_204_529 WHERE "album" = 'good rain') - 1
SELECT "album" FROM "table_204_529" WHERE "id" = (SELECT "id" FROM "table_204_529" WHERE "album" = 'good rain') - 1