Table: astronaut_flights
Columns: pilot
organization
total_flights
usaf_space_flights
fai_space_flights
max_mach
max_speed_mph
max_altitude_miles

Question: Who was the pilot of max altitude of 55.9 miles?
SQL: SELECT "pilot" FROM astronaut_flights WHERE "max_altitude_miles" = '55.9'

Question: What is the highest number of fai space flights when max mach is 5.65?
SQL: SELECT MAX("fai_space_flights") FROM astronaut_flights WHERE "max_mach" = '5.65'

Question: What was the maximum altitude for Neil Armstrong?
SQL: SELECT "max_altitude_miles" FROM astronaut_flights WHERE "pilot" = 'Neil Armstrong'

Question: How many numbers were recorded under max speed for 1 USAF space flight and total flights 34?
SQL: SELECT COUNT("max_speed_mph") FROM astronaut_flights WHERE "usaf_space_flights" = 1 AND "total_flights" = 34

Question: What were all USAF space flights when the aximum speed was 3822?
SQL: SELECT "usaf_space_flights" FROM astronaut_flights WHERE "max_speed_mph" = 3822

Question: What was the max mach when the maximum speed was 3887?
SQL: SELECT "max_mach" FROM astronaut_flights WHERE "max_speed_mph" = 3887