Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Em que ano as Olimpíadas, o Canadá e o evento Men's Eight terminaram com uma medalha de prata?
 ###Tabelas: CREATE TABLE season_12:_2008_2009 (season_12:_2008_2009_id AUTO_INCREMENT PRIMARY KEY, Series Ep. VARCHAR, Episode INT, Netflix VARCHAR, Segment A VARCHAR, Segment B VARCHAR, Segment C VARCHAR, Segment D VARCHAR) CREATE TABLE listing (listing_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Population ( 2011 Census ) INT, Percent of national population VARCHAR, % growth (2006–11) VARCHAR, Land area (km²) INT, Population density (/km 2 ) INT, House of Commons seats INT, House of Commons seats (%) VARCHAR, 2013 population (July est.) INT) CREATE TABLE parties_involved_in_the_2007_government_formation (parties_involved_in_the_2007_government_formation_id AUTO_INCREMENT PRIMARY KEY, From VARCHAR, Until VARCHAR, Name VARCHAR, Party VARCHAR, Function VARCHAR) CREATE TABLE major_achievements (major_achievements_id AUTO_INCREMENT PRIMARY KEY, Year INT, Competition VARCHAR, Venue VARCHAR, Position VARCHAR, Event VARCHAR, Notes VARCHAR) CREATE TABLE coaching_titles (coaching_titles_id AUTO_INCREMENT PRIMARY KEY, Year INT, Championship VARCHAR, Event VARCHAR, Nation VARCHAR, Result VARCHAR)  
SELECT MAX Year FROM coaching_titles WHERE Championship = olympics AND Event = men's eight AND Nation = canada AND Result = silver