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