What is the total of all Shot PCT occurrences when the value of Blank Ends is 8?
CREATE TABLE "round_robin_standings" (
  "locale" text,
  "skip" text,
  "w" real,
  "l" real,
  "pf" real,
  "pa" real,
  "ends_won" real,
  "ends_lost" real,
  "blank_ends" real,
  "stolen_ends" real,
  "shot_pct" text
);
SELECT COUNT("shot_pct") FROM "round_robin_standings" WHERE "blank_ends"=8;