What is CFL Team, when Pick # is greater than 34, and when College is Boise State?
CREATE TABLE table_name_86 (cfl_team VARCHAR, pick__number VARCHAR, college VARCHAR)
SELECT cfl_team FROM table_name_86 WHERE pick__number > 34 AND college = "boise state"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (cfl_team VARCHAR, pick__number VARCHAR, college VARCHAR) Question: What is CFL Team, when Pick # is greater than 34, and when College is Boise State? [/INST] SELECT cfl_team FROM table_name_86 WHERE pick__number > 34 AND college = "boise state" </s>