What year was olympics, Canada and the Men's Eight Event ended with a silver medal?
CREATE TABLE table_name_92 (year INTEGER, result VARCHAR, nation VARCHAR, championship VARCHAR, event VARCHAR)
SELECT MAX(year) FROM table_name_92 WHERE championship = "olympics" AND event = "men's eight" AND nation = "canada" AND result = "silver"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_92 (year INTEGER, result VARCHAR, nation VARCHAR, championship VARCHAR, event VARCHAR) Question: What year was olympics, Canada and the Men's Eight Event ended with a silver medal? [/INST] SELECT MAX(year) FROM table_name_92 WHERE championship = "olympics" AND event = "men's eight" AND nation = "canada" AND result = "silver" </s>