CREATE TABLE table_name_95 (team VARCHAR, replaced_by VARCHAR)

I want the team for replaced by mark mcghee
SELECT team FROM table_name_95 WHERE replaced_by = "mark mcghee"
SELECT "team" FROM "table_name_95" WHERE "mark mcghee" = "replaced_by"