CREATE TABLE table_2897457_4 (player VARCHAR(255), position VARCHAR(255), nhl_team VARCHAR(255))
Which player is the centre for the Detroit Red Wings?
    
SQL: SELECT player FROM table_2897457_4 WHERE position = "Centre" AND nhl_team = "Detroit Red Wings"