What's the highest Year Left that's got a Conference Joined of Sagamore with a Year Joined larger than 1942?
CREATE TABLE table_name_3 (year_left INTEGER, conference_joined VARCHAR, year_joined VARCHAR)
SELECT MAX(year_left) FROM table_name_3 WHERE conference_joined = "sagamore" AND year_joined > 1942
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (year_left INTEGER, conference_joined VARCHAR, year_joined VARCHAR) Question: What's the highest Year Left that's got a Conference Joined of Sagamore with a Year Joined larger than 1942? [/INST] SELECT MAX(year_left) FROM table_name_3 WHERE conference_joined = "sagamore" AND year_joined > 1942 </s>