Table: spaceflight_2009
Columns: rocket
country
type
launches
successes
failures
partial_failures

Question: What's the total failures among rockets that had more than 3 successes, type ariane 5 and more than 0 partial failures?
SQL: SELECT COUNT("failures") FROM spaceflight_2009 WHERE "successes" > 3 AND "type" = 'ariane 5' AND "partial_failures" > 0

Question: What is the number of successes for rockets that have more than 3 launches, were based in Russia, are type soyuz and a rocket type of soyuz-u?
SQL: SELECT COUNT("successes") FROM spaceflight_2009 WHERE "launches" > 3 AND "country" = 'russia' AND "type" = 'soyuz' AND "rocket" = 'soyuz-u'