question: What Outgoing manager left at his end of tenure as caretaker and was Replaced by Jesper Hansen?
answer: SELECT outgoing_manager FROM table_name_78 WHERE manner_of_departure = "end of tenure as caretaker" AND replaced_by = "jesper hansen"
context: CREATE TABLE table_name_78 (outgoing_manager VARCHAR, manner_of_departure VARCHAR, replaced_by VARCHAR)