CREATE TABLE table_7687 ("Player" CLOB, "Att." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "Long" FLOAT)

Which Yards has a Long smaller than 3?
SELECT AVG("Yards") FROM table_7687 WHERE "Long" < '3'
SELECT AVG("Yards") FROM "table_7687" WHERE "Long" < '3'