Which player is the centre for the Detroit Red Wings?
CREATE TABLE table_2897457_4 (player VARCHAR, position VARCHAR, nhl_team VARCHAR)
SELECT player FROM table_2897457_4 WHERE position = "Centre" AND nhl_team = "Detroit Red Wings"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2897457_4 (player VARCHAR, position VARCHAR, nhl_team VARCHAR) Question: Which player is the centre for the Detroit Red Wings? [/INST] SELECT player FROM table_2897457_4 WHERE position = "Centre" AND nhl_team = "Detroit Red Wings" </s>