CREATE TABLE table_name_40 (outgoing_manager VARCHAR(255), replaced_by VARCHAR(255))
I want the outgoing manager for craig brewster
    
SQL: SELECT outgoing_manager FROM table_name_40 WHERE replaced_by = "craig brewster"