What's the pick for the New York jets with a defensive end?
CREATE TABLE table_name_54 (pick VARCHAR, position VARCHAR, team VARCHAR)
SELECT pick FROM table_name_54 WHERE position = "defensive end" AND team = "new york jets"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (pick VARCHAR, position VARCHAR, team VARCHAR) Question: What's the pick for the New York jets with a defensive end? [/INST] SELECT pick FROM table_name_54 WHERE position = "defensive end" AND team = "new york jets" </s>