CREATE TABLE table_name_74 (term_in_office VARCHAR2, member VARCHAR2)

When was Hon Les Johnson in office?
SELECT term_in_office FROM table_name_74 WHERE member = "hon les johnson"
SELECT "term_in_office" FROM "table_name_74" WHERE "hon les johnson" = "member"