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

How many players had been drafted in front of Yves archambault
SELECT "Pick #" FROM table_1100 WHERE "Player" = 'Yves Archambault'
SELECT "Pick #" FROM "table_1100" WHERE "Player" = 'Yves Archambault'