When east carolina university is the school what is the highest year founded?
CREATE TABLE table_2076516_1 (founded INTEGER, school VARCHAR)
SELECT MAX(founded) FROM table_2076516_1 WHERE school = "East Carolina University"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2076516_1 (founded INTEGER, school VARCHAR) Question: When east carolina university is the school what is the highest year founded? [/INST] SELECT MAX(founded) FROM table_2076516_1 WHERE school = "East Carolina University" </s>