What Outgoing manager left at his end of tenure as caretaker and was Replaced by Jesper Hansen?
CREATE TABLE table_name_78 (outgoing_manager VARCHAR, manner_of_departure VARCHAR, replaced_by VARCHAR)
SELECT outgoing_manager FROM table_name_78 WHERE manner_of_departure = "end of tenure as caretaker" AND replaced_by = "jesper hansen"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (outgoing_manager VARCHAR, manner_of_departure VARCHAR, replaced_by VARCHAR) Question: What Outgoing manager left at his end of tenure as caretaker and was Replaced by Jesper Hansen? [/INST] SELECT outgoing_manager FROM table_name_78 WHERE manner_of_departure = "end of tenure as caretaker" AND replaced_by = "jesper hansen" </s>