If the pick is under 28 and the position is k, what's the highest Overall pick?
CREATE TABLE table_name_55 (overall INTEGER, position VARCHAR, pick VARCHAR)
SELECT MAX(overall) FROM table_name_55 WHERE position = "k" AND pick < 28
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (overall INTEGER, position VARCHAR, pick VARCHAR) Question: If the pick is under 28 and the position is k, what's the highest Overall pick? [/INST] SELECT MAX(overall) FROM table_name_55 WHERE position = "k" AND pick < 28 </s>