Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1?
CREATE TABLE "most_starts" (
  "name" text,
  "period" text,
  "starts" real,
  "wins" real,
  "losses" real,
  "ties" real,
  "win_pct" real
);
SELECT SUM("wins") FROM "most_starts" WHERE "win_pct"<0.8270000000000001 AND "name"='rick mirer' AND "ties"<1;