CREATE TABLE table_2098 ("Pick #" FLOAT, "Player" CLOB, "Position" CLOB, "Nationality" CLOB, "NHL team" CLOB, "College/junior/club team" CLOB)

What player was drafted to the Detroit Red Wings?
SELECT "Player" FROM table_2098 WHERE "NHL team" = 'Detroit Red Wings'
SELECT "Player" FROM "table_2098" WHERE "NHL team" = 'Detroit Red Wings'