CREATE TABLE table_11823 ("Player" CLOB, "Car." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

What is the average for the RB with an 8 yard long?
SELECT COUNT("Avg.") FROM table_11823 WHERE "Long" = '8'
SELECT COUNT("Avg.") FROM "table_11823" WHERE "Long" = '8'