CREATE TABLE table_35031 ("Player" CLOB, "Rec." FLOAT, "Yards" FLOAT, "Average" FLOAT, "s Touchdown" FLOAT, "Year" FLOAT, "Opponent" CLOB)

Which rec has Yards of 192, and a Touchdown smaller than 1?
SELECT AVG("Rec.") FROM table_35031 WHERE "Yards" = '192' AND "s Touchdown" < '1'
SELECT AVG("Rec.") FROM "table_35031" WHERE "Yards" = '192' AND "s Touchdown" < '1'