How many Played has a % Win of 50.00%, and Losses of 1, and Wins smaller than 1?
CREATE TABLE "summary_of_results_by_season" (
  "year" text,
  "played" real,
  "wins" real,
  "losses" real,
  "no_result" real,
  "pct_win" text
);
SELECT COUNT("played") FROM "summary_of_results_by_season" WHERE "pct_win"='50.00%' AND "losses"=1 AND "wins"<1;