What is the highest round that has an overall of 143 and a pick greater than 6?
CREATE TABLE table_name_36 (round INTEGER, overall VARCHAR, pick VARCHAR)
SELECT MAX(round) FROM table_name_36 WHERE overall = 143 AND pick > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_36 (round INTEGER, overall VARCHAR, pick VARCHAR) Question: What is the highest round that has an overall of 143 and a pick greater than 6? [/INST] SELECT MAX(round) FROM table_name_36 WHERE overall = 143 AND pick > 6 </s>