Which Yards has an Avg larger than 7, and a Long smaller than 60, and a Rec larger than 19, and a Player of correll buckhalter?
CREATE TABLE table_name_90 (yards INTEGER, player VARCHAR, rec VARCHAR, avg VARCHAR, long VARCHAR)
SELECT AVG(yards) FROM table_name_90 WHERE avg > 7 AND long < 60 AND rec > 19 AND player = "correll buckhalter"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_90 (yards INTEGER, player VARCHAR, rec VARCHAR, avg VARCHAR, long VARCHAR) Question: Which Yards has an Avg larger than 7, and a Long smaller than 60, and a Rec larger than 19, and a Player of correll buckhalter? [/INST] SELECT AVG(yards) FROM table_name_90 WHERE avg > 7 AND long < 60 AND rec > 19 AND player = "correll buckhalter" </s>