What is the average Yards with an average of less than 4 and the long is 12 with less than 29 attempts?
CREATE TABLE table_name_53 (yards INTEGER, attempts VARCHAR, average VARCHAR, long VARCHAR)
SELECT AVG(yards) FROM table_name_53 WHERE average < 4 AND long = 12 AND attempts < 29
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_53 (yards INTEGER, attempts VARCHAR, average VARCHAR, long VARCHAR) Question: What is the average Yards with an average of less than 4 and the long is 12 with less than 29 attempts? [/INST] SELECT AVG(yards) FROM table_name_53 WHERE average < 4 AND long = 12 AND attempts < 29 </s>