Table: corona_satellite
Columns: mission_no
cover_name
launch_date
nssdc_id_no
alt_name
camera
notes

Question: Which mission number has alternate name 1962-f01
SQL: SELECT "mission_no" FROM corona_satellite WHERE "alt_name" = '1962-F01'

Question: What are the notes of the satellite whose nssdc id number is 1959-002a?
SQL: SELECT "notes" FROM corona_satellite WHERE "nssdc_id_no" = '1959-002A'

Question: What are the alternative name/s of those satellites whose nssdc id number is 1970-054a?
SQL: SELECT "alt_name" FROM corona_satellite WHERE "nssdc_id_no" = '1970-054A'

Question: What are the alternative names of those satellites where the notes are: mission failed. guidance system failed. no orbit.
SQL: SELECT "alt_name" FROM corona_satellite WHERE "notes" = 'Mission failed. Guidance system failed. No orbit.'