CREATE TABLE table_name_7 (avg VARCHAR, long VARCHAR)

What is the average for the RB with an 8 yard long?
SELECT COUNT(avg) FROM table_name_7 WHERE long = 8
SELECT COUNT("avg") FROM "table_name_7" WHERE "long" = 8