How many total No Results are recorded for less than 6 wins?
CREATE TABLE "summary_of_results" (
  "matches" real,
  "wins" real,
  "losses" real,
  "no_result" real,
  "success_rate" text
);
SELECT COUNT("no_result") FROM "summary_of_results" WHERE "wins"<6;