How many longs have a gain less than 379, and 0.8 as an avg/g?
CREATE TABLE "rushing" (
  "name" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT SUM("long") FROM "rushing" WHERE "gain"<379 AND "avg_g"=0.8;