What is the sum shot % when the country is finland, and an ends lost is larger than 49?
CREATE TABLE "standings" (
  "country" text,
  "skip" text,
  "ends_won" real,
  "ends_lost" real,
  "blank_ends_f_a" text,
  "stolen_ends_for" real,
  "stolen_ends_against" real,
  "shot_pct" real
);
SELECT SUM("shot_pct") FROM "standings" WHERE "country"='finland' AND "ends_lost">49;