CREATE TABLE table_name_8 (mission VARCHAR, name VARCHAR)

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