Table: league_manager_changes_8
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment
position_in_table

Question: WHo was the outgoing manager for the team of fc carl zeiss jena?
SQL: SELECT "outgoing_manager" FROM league_manager_changes_8 WHERE "team" = 'fc carl zeiss jena'

Question: What team did the manager come from who departed due to an end of tenure as caretaker?
SQL: SELECT "team" FROM league_manager_changes_8 WHERE "manner_of_departure" = 'end of tenure as caretaker'

Question: What was the date of appointment for the replaced manager, reiner geyer?
SQL: SELECT "date_of_appointment" FROM league_manager_changes_8 WHERE "replaced_by" = 'reiner geyer'

Question: What was the date of vacancy after the outgoing manager, ralf santelli departed?
SQL: SELECT "date_of_vacancy" FROM league_manager_changes_8 WHERE "outgoing_manager" = 'ralf santelli'

Question: Who was the outgoing manager who departed due to fc energie cottbus purchased rights?
SQL: SELECT "outgoing_manager" FROM league_manager_changes_8 WHERE "manner_of_departure" = 'fc energie cottbus purchased rights'