Table: spaceflight_2010_2
Columns: country
launches
successes
failures
partial_failures

Question: Failures larger than 0, and a Successes of 1 has what lowest partial failures?
SQL: SELECT MIN("partial_failures") FROM spaceflight_2010_2 WHERE "failures" > 0 AND "successes" = 1

Question: Successes smaller than 6, and Launches larger than 1, and a Failures of 2 is what sum of the partial failures?
SQL: SELECT SUM("partial_failures") FROM spaceflight_2010_2 WHERE "successes" < 6 AND "launches" > 1 AND "failures" = 2