What was the term of office for noel beaton?
CREATE TABLE table_name_1 (term_of_office VARCHAR, member VARCHAR)
SELECT term_of_office FROM table_name_1 WHERE member = "noel beaton"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (term_of_office VARCHAR, member VARCHAR) Question: What was the term of office for noel beaton? [/INST] SELECT term_of_office FROM table_name_1 WHERE member = "noel beaton" </s>