Who was the manager that was positioned 11th in table and resigned in departure?
CREATE TABLE table_name_30 (replaced_by VARCHAR, position_in_table VARCHAR, manner_of_departure VARCHAR)
SELECT replaced_by FROM table_name_30 WHERE position_in_table = "11th" AND manner_of_departure = "resigned"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (replaced_by VARCHAR, position_in_table VARCHAR, manner_of_departure VARCHAR) Question: Who was the manager that was positioned 11th in table and resigned in departure? [/INST] SELECT replaced_by FROM table_name_30 WHERE position_in_table = "11th" AND manner_of_departure = "resigned" </s>