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

Which NHL team has player Mike Loach?
SELECT "NHL team" FROM table_15979 WHERE "Player" = 'Mike Loach'
SELECT "NHL team" FROM "table_15979" WHERE "Player" = 'Mike Loach'