Which year did the Short Pump Town Center Mall open?
CREATE TABLE table_name_4 (year_opened VARCHAR, mall_name VARCHAR)
SELECT year_opened FROM table_name_4 WHERE mall_name = "short pump town center"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (year_opened VARCHAR, mall_name VARCHAR) Question: Which year did the Short Pump Town Center Mall open? [/INST] SELECT year_opened FROM table_name_4 WHERE mall_name = "short pump town center" </s>