How many losses have jake sharp as the name, with a long less than 30?
CREATE TABLE "rushing" (
  "name" text,
  "gain" real,
  "loss" real,
  "long" real,
  "avg_g" real
);
SELECT COUNT("loss") FROM "rushing" WHERE "name"='jake sharp' AND "long"<30;