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

I want the team for replaced by mark mcghee
SELECT "Team" FROM table_10575 WHERE "Replaced by" = 'mark mcghee'
SELECT "Team" FROM "table_10575" WHERE "Replaced by" = 'mark mcghee'