user: ### NOW ANSWER:
Question: I want the outgoing manager for Craig Brewster
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Replaced by', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Motherwell', 'Maurice Malpas', 'Sacked', 'Mark McGhee', '1 June 2007']
SQL:

assistant: SELECT "Outgoing manager" FROM "Table" WHERE "Replaced by" = 'Craig Brewster';