Failures larger than 0, and a Successes of 1 has what lowest partial failures?
CREATE TABLE "by_country" (
  "country" text,
  "launches" real,
  "successes" real,
  "failures" real,
  "partial_failures" real
);
SELECT MIN("partial_failures") FROM "by_country" WHERE "failures">0 AND "successes"=1;