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

Which Pick # has an NHL team of detroit red wings?
SELECT "Pick #" FROM table_79872 WHERE "NHL team" = 'detroit red wings'
SELECT "Pick #" FROM "table_79872" WHERE "NHL team" = 'detroit red wings'