How many TDs for the player with a long of less than 4 and under 8 yards?
CREATE TABLE "running_backs" (
  "player" text,
  "car" real,
  "yards" real,
  "avg" real,
  "td_s" real,
  "long" real
);
SELECT SUM("td_s") FROM "running_backs" WHERE "long"<4 AND "yards"<8;