CREATE TABLE table_name_99 (yards VARCHAR2, avg VARCHAR2, rec VARCHAR2)

Name the total number of yards for avg of 9 and rec of 1
SELECT COUNT(yards) FROM table_name_99 WHERE avg = 9 AND rec = 1
SELECT COUNT("yards") FROM "table_name_99" WHERE "avg" = 9 AND "rec" = 1