How many picks have canada as the nationality and larry courville is the player?
CREATE TABLE table_2886617_3 (pick VARCHAR, nationality VARCHAR, player VARCHAR)
SELECT COUNT(pick) FROM table_2886617_3 WHERE nationality = "Canada" AND player = "Larry Courville"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2886617_3 (pick VARCHAR, nationality VARCHAR, player VARCHAR) Question: How many picks have canada as the nationality and larry courville is the player? [/INST] SELECT COUNT(pick) FROM table_2886617_3 WHERE nationality = "Canada" AND player = "Larry Courville" </s>