What is the long figure when gain is less than 0?
CREATE TABLE "rushing" (
  "name" text,
  "gp_gs" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT AVG("long") FROM "rushing" WHERE "gain"<0;