Which rec has Yards of 192, and a Touchdown smaller than 1?
CREATE TABLE "michigan_single_game_reception_yardage" (
  "player" text,
  "rec" real,
  "yards" real,
  "average" real,
  "s_touchdown" real,
  "year" real,
  "opponent" text
);
SELECT AVG("rec") FROM "michigan_single_game_reception_yardage" WHERE "yards"=192 AND "s_touchdown"<1;