What is total number of years that has genre of first-person shooter?
CREATE TABLE table_name_50 (year INTEGER, genre VARCHAR)
SELECT SUM(year) FROM table_name_50 WHERE genre = "first-person shooter"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (year INTEGER, genre VARCHAR) Question: What is total number of years that has genre of first-person shooter? [/INST] SELECT SUM(year) FROM table_name_50 WHERE genre = "first-person shooter" </s>