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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: I want the outgoing manager for craig brewster ### Input: CREATE TABLE table_name_40 (
    outgoing_manager VARCHAR,
    replaced_by VARCHAR
) ### Response: SELECT outgoing_manager FROM table_name_40 WHERE replaced_by = "craig brewster"