CREATE TABLE table_2897457_4 (player VARCHAR, position VARCHAR, nhl_team VARCHAR)

Which player is the centre for the Detroit Red Wings?
SELECT player FROM table_2897457_4 WHERE position = "Centre" AND nhl_team = "Detroit Red Wings"
SELECT "player" FROM "table_2897457_4" WHERE "Centre" = "position" AND "Detroit Red Wings" = "nhl_team"