I want the outgoing manager for craig brewster
CREATE TABLE table_name_40 (outgoing_manager VARCHAR, replaced_by VARCHAR)
SELECT outgoing_manager FROM table_name_40 WHERE replaced_by = "craig brewster"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (outgoing_manager VARCHAR, replaced_by VARCHAR) Question: I want the outgoing manager for craig brewster [/INST] SELECT outgoing_manager FROM table_name_40 WHERE replaced_by = "craig brewster" </s>