What is the total gain for Brandon Mcrae with a loss less than 4, and an Avg/g less than -0.1?
CREATE TABLE "rushing" (
  "name" text,
  "gp_gs" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT COUNT("gain") FROM "rushing" WHERE "long"<4 AND "name"='brandon mcrae' AND "avg_g"<-0.1;