question: What is the date settled for 40 years?
answer: SELECT date_first_settled_as_a_suburb FROM table_1174162_1 WHERE median_age__in_2006_ = "40 years"
context: CREATE TABLE table_1174162_1 (date_first_settled_as_a_suburb VARCHAR, median_age__in_2006_ VARCHAR)