Successes smaller than 6, and Launches larger than 1, and a Failures of 2 is what sum of the partial failures?
CREATE TABLE "by_country" (
  "country" text,
  "launches" real,
  "successes" real,
  "failures" real,
  "partial_failures" real
);
SELECT SUM("partial_failures") FROM "by_country" WHERE "successes"<6 AND "launches">1 AND "failures"=2;