user: ### NOW ANSWER:
Question: How many players had been drafted in front of Yves Archambault
Columns: ['Pick #', 'Player', 'Position', 'Nationality', 'NHL team', 'College/junior/club team']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [97.0, 'Richard Brodeur', 'Goaltender', 'Canada', 'New York Islanders', 'Cornwall Royals (QMJHL)']
SQL:

assistant: SELECT "Pick #" FROM "Table" WHERE "Player" = 'Yves Archambault';