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

How many teams have a player named Denis Andersen?
SELECT COUNT("NHL team") FROM table_2100 WHERE "Player" = 'Denis Andersen'
SELECT COUNT("NHL team") FROM "table_2100" WHERE "Player" = 'Denis Andersen'