Tell me the lowest avg for 6 yards and rec more than 1
CREATE TABLE table_name_16 (avg INTEGER, yards VARCHAR, rec VARCHAR)
SELECT MIN(avg) FROM table_name_16 WHERE yards = 6 AND rec > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_16 (avg INTEGER, yards VARCHAR, rec VARCHAR) Question: Tell me the lowest avg for 6 yards and rec more than 1 [/INST] SELECT MIN(avg) FROM table_name_16 WHERE yards = 6 AND rec > 1 </s>