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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (mission VARCHAR, name VARCHAR) Question: David Scott went on which mission? [/INST] SELECT mission FROM table_name_8 WHERE name = "david scott" </s>