How many yards were averaged by the player that had a higher than 13 average with less than 18 long?
CREATE TABLE table_name_94 (yards INTEGER, long VARCHAR, avg VARCHAR)
SELECT AVG(yards) FROM table_name_94 WHERE long < 18 AND avg > 13
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (yards INTEGER, long VARCHAR, avg VARCHAR) Question: How many yards were averaged by the player that had a higher than 13 average with less than 18 long? [/INST] SELECT AVG(yards) FROM table_name_94 WHERE long < 18 AND avg > 13 </s>