What is the most recent year founded that has a nickname of bruins?
CREATE TABLE table_name_7 (founded INTEGER, nickname VARCHAR)
SELECT MAX(founded) FROM table_name_7 WHERE nickname = "bruins"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (founded INTEGER, nickname VARCHAR) Question: What is the most recent year founded that has a nickname of bruins? [/INST] SELECT MAX(founded) FROM table_name_7 WHERE nickname = "bruins" </s>