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: Qual é o ano em que Hagerstown se juntou?
 ###Tabelas: CREATE TABLE 2007_regular_season_football_standings (2007_regular_season_football_standings_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Team VARCHAR, Division Record VARCHAR, Overall Record VARCHAR, Season Outcome VARCHAR) CREATE TABLE composition_of_the_6th_seanad (composition_of_the_6th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE summer_2001 (summer_2001_id AUTO_INCREMENT PRIMARY KEY, 7:00 am VARCHAR, 7:30 am VARCHAR, 8:00 am VARCHAR, 9:00 am VARCHAR, 11:00 am VARCHAR, noon VARCHAR, 12:30 pm VARCHAR, 1:00 pm VARCHAR, 1:30 pm VARCHAR, 2:00 pm VARCHAR, 3:00 pm VARCHAR, 3:30 pm VARCHAR, 4:00 pm VARCHAR, 4:30 pm VARCHAR, 5:00 pm VARCHAR, 6:30 pm VARCHAR) CREATE TABLE membership (membership_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Mascot VARCHAR, Size INT, IHSAA Class VARCHAR, # / County VARCHAR, Year Joined INT, Previous Conference VARCHAR) CREATE TABLE anglo-italian_cup (anglo-italian_cup_id AUTO_INCREMENT PRIMARY KEY, Opposing Team VARCHAR, Against INT, Date VARCHAR, Venue VARCHAR, Round VARCHAR)  
SELECT Year Joined FROM membership WHERE School = hagerstown