What was the pic for Canada for player Yvon Bouillon earlier than 1974?
CREATE TABLE table_name_38 (pick INTEGER, player VARCHAR, nationality VARCHAR, year VARCHAR)
SELECT AVG(pick) FROM table_name_38 WHERE nationality = "canada" AND year < 1974 AND player = "yvon bouillon"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_38 (pick INTEGER, player VARCHAR, nationality VARCHAR, year VARCHAR) Question: What was the pic for Canada for player Yvon Bouillon earlier than 1974? [/INST] SELECT AVG(pick) FROM table_name_38 WHERE nationality = "canada" AND year < 1974 AND player = "yvon bouillon" </s>