How many players had been drafted in front of Yves archambault
CREATE TABLE table_1473672_7 (pick__number VARCHAR, player VARCHAR)
SELECT pick__number FROM table_1473672_7 WHERE player = "Yves Archambault"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1473672_7 (pick__number VARCHAR, player VARCHAR) Question: How many players had been drafted in front of Yves archambault [/INST] SELECT pick__number FROM table_1473672_7 WHERE player = "Yves Archambault" </s>