Table: rocket_tests
Columns: launch_vehicle
launch_date
mission
institutional_authority
launch_site
results

Question: Where did Test Mission: War Heads and Missile Payload launch when there was a partial failure?
SQL: SELECT "launch_site" FROM rocket_tests WHERE "mission" = 'Test Mission: war heads and Missile payload' AND "results" = 'Partial Failure'

Question: Which missions were scheduled to launch on November 16, 2006?
SQL: SELECT "mission" FROM rocket_tests WHERE "launch_date" = 'November 16, 2006'