What is the total number of Points with less than 1 tries, and more than 0 goals?
CREATE TABLE "scorers" (
  "player" text,
  "tries" real,
  "goals" real,
  "field_goals" real,
  "points" real
);
SELECT COUNT("points") FROM "scorers" WHERE "tries"<1 AND "goals">0;