Schema: CREATE TABLE table_name_1 (term_of_office VARCHAR, member VARCHAR)
Question: What was the term of office for noel beaton?
SQL: SELECT term_of_office FROM table_name_1 WHERE member = "noel beaton"