What is the average opened year of line e, which had their last extension before 2003?
CREATE TABLE table_name_40 (opened INTEGER, line_name VARCHAR, last_extension VARCHAR)
SELECT AVG(opened) FROM table_name_40 WHERE line_name = "line e" AND last_extension < 2003
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (opened INTEGER, line_name VARCHAR, last_extension VARCHAR) Question: What is the average opened year of line e, which had their last extension before 2003? [/INST] SELECT AVG(opened) FROM table_name_40 WHERE line_name = "line e" AND last_extension < 2003 </s>