What is the date settled for 40 years?
CREATE TABLE table_1174162_1 (date_first_settled_as_a_suburb VARCHAR, median_age__in_2006_ VARCHAR)
SELECT date_first_settled_as_a_suburb FROM table_1174162_1 WHERE median_age__in_2006_ = "40 years"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1174162_1 (date_first_settled_as_a_suburb VARCHAR, median_age__in_2006_ VARCHAR) Question: What is the date settled for 40 years? [/INST] SELECT date_first_settled_as_a_suburb FROM table_1174162_1 WHERE median_age__in_2006_ = "40 years" </s>