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 o Shopping Short Pump Town Center Mall abriu?
 ###Tabelas: CREATE TABLE season_2:_2002 (season_2:_2002_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 general_information__&__feature_comparison (general_information__&__feature_comparison_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Year Began VARCHAR, s Registered user VARCHAR, Updated in past 30 days VARCHAR, Registration VARCHAR, Ability to syndicate off-site feeds VARCHAR, Userpics Free VARCHAR, Userpics Paid VARCHAR, Monthly Cost for Paid Account VARCHAR, Yearly Cost for Paid Account VARCHAR, Permanent Account VARCHAR) CREATE TABLE verified_aerial_victories (verified_aerial_victories_id AUTO_INCREMENT PRIMARY KEY, Number INT, Time INT, Aircraft VARCHAR, Opponent VARCHAR, Location VARCHAR) CREATE TABLE results_by_team (results_by_team_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Winners INT, Last final won VARCHAR, Runners-up INT, Last final lost VARCHAR) CREATE TABLE statistics (statistics_id AUTO_INCREMENT PRIMARY KEY, Mall name VARCHAR, Location VARCHAR, Retail space Sq. feet/(m²) VARCHAR, Stores VARCHAR, Year opened INT)  
SELECT Year opened FROM statistics WHERE Mall name = short pump town center