CREATE TABLE table_10574 ("Team" CLOB, "Outgoing manager" CLOB, "Manner of departure" CLOB, "Replaced by" CLOB, "Date of appointment" CLOB)

I want the outgoing manager for craig brewster
SELECT "Outgoing manager" FROM table_10574 WHERE "Replaced by" = 'craig brewster'
SELECT "Outgoing manager" FROM "table_10574" WHERE "Replaced by" = 'craig brewster'