Which average Long has a Gain smaller than 16, and a Loss smaller than 6?
CREATE TABLE "rushing" (
  "name" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT AVG("long") FROM "rushing" WHERE "gain"<16 AND "loss"<6;