What was the average for the player that scored 116 yards and had TD's less than 1?
CREATE TABLE "wide_receivers" (
  "player" text,
  "rec" real,
  "yards" real,
  "avg" real,
  "td_s" real,
  "long" real
);
SELECT COUNT("avg") FROM "wide_receivers" WHERE "yards"=116 AND "td_s"<1;