WHAT IS THE NUMBER OF LOSSES WITH A LONG SMALLER THAN 24, AND GAIN BIGGER THAN 116?
CREATE TABLE "rushing" (
  "name" text,
  "gp_gs" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT COUNT("loss") FROM "rushing" WHERE "long"<24 AND "gain">116;