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

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'