What is Position, when Pick # is less than 40, and when College is Western?
CREATE TABLE table_name_40 (position VARCHAR, pick__number VARCHAR, college VARCHAR)
SELECT position FROM table_name_40 WHERE pick__number < 40 AND college = "western"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (position VARCHAR, pick__number VARCHAR, college VARCHAR) Question: What is Position, when Pick # is less than 40, and when College is Western? [/INST] SELECT position FROM table_name_40 WHERE pick__number < 40 AND college = "western" </s>