CREATE TABLE table_name_1 (term_of_office VARCHAR, member VARCHAR)

What was the term of office for noel beaton?
SELECT term_of_office FROM table_name_1 WHERE member = "noel beaton"
SELECT "term_of_office" FROM "table_name_1" WHERE "member" = "noel beaton"