I want to know the longest Long for santana moss and Att more than 1
CREATE TABLE table_name_5 (long INTEGER, player VARCHAR, att VARCHAR)
SELECT MIN(long) FROM table_name_5 WHERE player = "santana moss" AND att > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_5 (long INTEGER, player VARCHAR, att VARCHAR) Question: I want to know the longest Long for santana moss and Att more than 1 [/INST] SELECT MIN(long) FROM table_name_5 WHERE player = "santana moss" AND att > 1 </s>