CREATE TABLE table_47897 ("Team" TEXT, "Outgoing manager" TEXT, "Manner of departure" TEXT, "Date of vacancy" TEXT, "Replaced by" TEXT, "Date of appointment" TEXT, "Position in table" TEXT)

WHo was the outgoing manager for the team of fc carl zeiss jena?
SELECT "Outgoing manager" FROM table_47897 WHERE "Team" = 'fc carl zeiss jena'
SELECT "Outgoing manager" FROM "table_47897" WHERE "Team" = 'fc carl zeiss jena'