Name the total number of yards for avg of 9 and rec of 1
CREATE TABLE table_name_99 (yards VARCHAR, avg VARCHAR, rec VARCHAR)
SELECT COUNT(yards) FROM table_name_99 WHERE avg = 9 AND rec = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (yards VARCHAR, avg VARCHAR, rec VARCHAR) Question: Name the total number of yards for avg of 9 and rec of 1 [/INST] SELECT COUNT(yards) FROM table_name_99 WHERE avg = 9 AND rec = 1 </s>