CREATE TABLE table_name_97 (replaced_by VARCHAR2, team VARCHAR2)

who is the replacement when the team is port vale?
SELECT replaced_by FROM table_name_97 WHERE team = "port vale"
SELECT "replaced_by" FROM "table_name_97" WHERE "port vale" = "team"