Who was the supervisor in the year 1846?
CREATE TABLE table_name_43 (supervisor VARCHAR, years VARCHAR)
SELECT supervisor FROM table_name_43 WHERE years = "1846"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (supervisor VARCHAR, years VARCHAR) Question: Who was the supervisor in the year 1846? [/INST] SELECT supervisor FROM table_name_43 WHERE years = "1846" </s>