how many parts does detroit red wings person urban nordin play
CREATE TABLE table_2850912_8 (position VARCHAR, nhl_team VARCHAR, player VARCHAR)
SELECT COUNT(position) FROM table_2850912_8 WHERE nhl_team = "Detroit Red Wings" AND player = "Urban Nordin"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2850912_8 (position VARCHAR, nhl_team VARCHAR, player VARCHAR) Question: how many parts does detroit red wings person urban nordin play [/INST] SELECT COUNT(position) FROM table_2850912_8 WHERE nhl_team = "Detroit Red Wings" AND player = "Urban Nordin" </s>