For how many years was the location at Beijing?
CREATE TABLE table_name_7 (year INTEGER, location VARCHAR)
SELECT SUM(year) FROM table_name_7 WHERE location = "beijing"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (year INTEGER, location VARCHAR) Question: For how many years was the location at Beijing? [/INST] SELECT SUM(year) FROM table_name_7 WHERE location = "beijing" </s>