David Scott went on which mission?
CREATE TABLE table_name_8 (mission VARCHAR, name VARCHAR)
SELECT mission FROM table_name_8 WHERE name = "david scott"
### Context: CREATE TABLE table_name_8 (mission VARCHAR, name VARCHAR) ### Question: David Scott went on which mission? ### Answer: SELECT mission FROM table_name_8 WHERE name = "david scott"