Table: spaceflight_2010_3
Columns: rocket
country
family
launches
successes
failures
partial_failures

Question: What were the average partial failures when the rocket was Ariane 5?
SQL: SELECT AVG("partial_failures") FROM spaceflight_2010_3 WHERE "rocket" = 'ariane 5'

Question: What are average launches with 0 failures, rocket of Soyuz, and less than 12 successes?
SQL: SELECT AVG("launches") FROM spaceflight_2010_3 WHERE "failures" = 0 AND "rocket" = 'soyuz' AND "successes" < 12

Question: What is the sum of launches with Long March 3 and 0 failures?
SQL: SELECT SUM("launches") FROM spaceflight_2010_3 WHERE "rocket" = 'long march 3' AND "failures" > 0

Question: What is the least amount of failures with 1 launch and 0 partial failures?
SQL: SELECT MIN("failures") FROM spaceflight_2010_3 WHERE "launches" = 1 AND "partial_failures" < 0

Question: What were the average launches for Ariane 5 and 0 partial failures?
SQL: SELECT AVG("launches") FROM spaceflight_2010_3 WHERE "rocket" = 'ariane 5' AND "partial_failures" < 0