How many percentages have losses fewer than 1 with finals appearances of 4?
CREATE TABLE "finals_appearances" (
  "finals" real,
  "team" text,
  "wins" real,
  "losses" real,
  "pct" real
);
SELECT COUNT("pct") FROM "finals_appearances" WHERE "losses"<1 AND "finals"=4;