What is the least amount of yards when the average is less than 2.6?
CREATE TABLE table_name_65 (yards INTEGER, average INTEGER)
SELECT MIN(yards) FROM table_name_65 WHERE average < 2.6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (yards INTEGER, average INTEGER) Question: What is the least amount of yards when the average is less than 2.6? [/INST] SELECT MIN(yards) FROM table_name_65 WHERE average < 2.6 </s>