Table schema:
CREATE TABLE table_name_8 (mission VARCHAR, name VARCHAR)

Question: David Scott went on which mission?
SQL: SELECT mission FROM table_name_8 WHERE name = "david scott"