Who is the pilot on September 27, 1972?
CREATE TABLE table_name_42 (pilot VARCHAR, date VARCHAR)
SELECT pilot FROM table_name_42 WHERE date = "september 27, 1972"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (pilot VARCHAR, date VARCHAR) Question: Who is the pilot on September 27, 1972? [/INST] SELECT pilot FROM table_name_42 WHERE date = "september 27, 1972" </s>