Which Player has a Round smaller than 11, and a Pick smaller than 152, and a Position of guard?
CREATE TABLE table_name_10 (player VARCHAR, position VARCHAR, round VARCHAR, pick VARCHAR)
SELECT player FROM table_name_10 WHERE round < 11 AND pick < 152 AND position = "guard"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (player VARCHAR, position VARCHAR, round VARCHAR, pick VARCHAR) Question: Which Player has a Round smaller than 11, and a Pick smaller than 152, and a Position of guard? [/INST] SELECT player FROM table_name_10 WHERE round < 11 AND pick < 152 AND position = "guard" </s>