CREATE TABLE table_204_494 (id NUMBER, "episode #" CLOB, "original air date  ( uk ) " CLOB, "episode title" CLOB, "guest cast" CLOB, "dvd # 1" NUMBER)

which episode was previous to target
SELECT "episode title" FROM table_204_494 WHERE id = (SELECT id FROM table_204_494 WHERE "episode title" = '"target"') - 1
SELECT "episode title" FROM "table_204_494" WHERE "id" = (SELECT "id" FROM "table_204_494" WHERE "episode title" = '"target"') - 1