Table: spaceflight_2010
Columns: orbital_regime
launches
successes
failures
accidentally_achieved

Question: What is the orbital regime of launches greater than 4 and failures less than 2?
SQL: SELECT "orbital_regime" FROM spaceflight_2010 WHERE "launches" > 4 AND "failures" < 2

Question: What is the total of medium earth orbital regime, accidentally achieved and successes greater than 3?
SQL: SELECT SUM("accidentally_achieved") FROM spaceflight_2010 WHERE "orbital_regime" = 'medium earth' AND "successes" > 3

Question: What is the greatest successes that have failures greater than 1 and launches less than 28?
SQL: SELECT MAX("successes") FROM spaceflight_2010 WHERE "failures" > 1 AND "launches" < 28

Question: What is the total failures of heliocentric orbit orbital regimes and launches less than 1?
SQL: SELECT SUM("failures") FROM spaceflight_2010 WHERE "orbital_regime" = 'heliocentric orbit' AND "launches" < 1