What is the average for the player with 1 TD, over 4 as a long, and under 1 carry?
CREATE TABLE "running_backs" (
  "player" text,
  "car" real,
  "yards" real,
  "avg" real,
  "td_s" real,
  "long" real
);
SELECT MIN("avg") FROM "running_backs" WHERE "td_s"=1 AND "long">4 AND "car"<1;