CREATE TABLE table_name_78 (outgoing_manager VARCHAR2, manner_of_departure VARCHAR2, replaced_by VARCHAR2)

What Outgoing manager left at his end of tenure as caretaker and was Replaced by Jesper Hansen?
SELECT outgoing_manager FROM table_name_78 WHERE manner_of_departure = "end of tenure as caretaker" AND replaced_by = "jesper hansen"
SELECT "outgoing_manager" FROM "table_name_78" WHERE "end of tenure as caretaker" = "manner_of_departure" AND "jesper hansen" = "replaced_by"