When the pick was below 42 and the player was Chris Horton, what's the highest Overall pick found?
CREATE TABLE table_name_15 (overall INTEGER, name VARCHAR, pick VARCHAR)
SELECT MAX(overall) FROM table_name_15 WHERE name = "chris horton" AND pick < 42
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_15 (overall INTEGER, name VARCHAR, pick VARCHAR) Question: When the pick was below 42 and the player was Chris Horton, what's the highest Overall pick found? [/INST] SELECT MAX(overall) FROM table_name_15 WHERE name = "chris horton" AND pick < 42 </s>